Re: check if stored procedure exists

From: <soup_or_power_at_yahoo.com>
Date: 20 Jul 2005 06:52:50 -0700
Message-ID: <1121867570.743205.91190@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/toc.htm
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/toc.htm
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/toc.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. Received on Wed Jul 20 2005 - 08:52:50 CDT