Re: check if stored procedure exists

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 20 Jul 2005 14:08:07 GMT
Message-ID: <Xns96994896184E0SunnySD@68.6.19.6>

soup_or_power_at_yahoo.com wrote in
news:1121867570.743205.91190_at_o13g2000cwo.googlegroups.com:

>
>
> IANAL_VISTA wrote:

>> soup_or_power_at_yahoo.com wrote in
>> news:1121864076.804265.175080_at_g43g2000cwa.googlegroups.com:
>>
>> > Hi
>> > Is there a way to check in PL/SQL if a stored procedure exists?
>> > Alternately, how can I catch the error when a stored procedure
>> > doesn't exist?
>> >
>> > Thanks for your time
>> >
>> >
>>
>> It is past time for you to RTFM
>> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/to
>> c.htm 
>>
>> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/to
>> c.htm 
>>
>> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/to
>> c.htm 

>
> RTFM=Read The First Message? :-)
> I was looking in the archives of CDOS and found a way to check by
> querying the user_source/dba_source table such as:
>
> select * from user_source where TYPE='PROCEDURE' and
> NAME='my_stored_procedure.'
>
> This will suffice for my needs at the moment. Is it the only way?
>
> Thanks for your help.
>
>

Alternatively DBA_OBJECTS could be queried. Received on Wed Jul 20 2005 - 09:08:07 CDT