Re: check if stored procedure exists

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 20 Jul 2005 13:17:13 GMT
Message-ID: <Xns96993FF4F1C4SunnySD@68.6.19.6>

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 Received on Wed Jul 20 2005 - 08:17:13 CDT