Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Not stored "stored procedure".

Re: Not stored "stored procedure".

From: Peter Mubaiter <this.is.not.valid_at_spammer.hola>
Date: Tue, 18 Jan 2005 11:40:38 +0100
Message-ID: <1106044862.118eea99db61b69fa387715bdc208b97@teranews>


Thomas Kyte wrote:
> and execute "set role none" before executing it :)
>
> SQL> set role none;
> SQL> declare ........
>
>
> else, what works as an anonymous block might well not have a chance of even
> compiling as a stored procedure.

Short question: Why that? Of course, I believe you but why is that so?

Thank you in advance,

Peter Received on Tue Jan 18 2005 - 04:40:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US