Re: Not stored "stored procedure".

In article <1106044862.118eea99db61b69fa387715bdc208b97_at_teranews>, Peter Mubaiter says...
>
>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

http://asktom.oracle.com/~tkyte/Misc/RolesAndProcedures.html

because roles are never enabled during the compilation of a stored procedure and roles are enabled during the execution of a definers rights stored procedure (the default and most common case)

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation