Re: Not stored "stored procedure".

In article <frunu0tnbvnaop86loi4slki9vvlrhn07e_at_4ax.com>, Sybrand Bakker says...
>
>On 17 Jan 2005 09:34:44 -0800, "Serguei" <gumenyuk_at_canada.com> wrote:
>
>>Dear Experts,
>>I have to test a stored procedure without inserting it's codes into a
>>database. How can I do this trick in Oracle?
>> Regards,
>> Serguei.
>
>convert it into an anonymous begin end block and run it through
>sql*plus. Parameters can be replaced by VARIABLES but of course they
>would need to be prefixed by a colon in the actual code.
>
>
>--
>Sybrand Bakker, Senior Oracle DBA

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.

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