Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Not stored "stored procedure".
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