Re: How to know if a procedure exists?

From: Winnie Liu <poohland_at_hotmail.com>
Date: Mon, 6 Jul 1998 20:26:55 -0700
Message-ID: <6ns4a5$cuj@sjx-ixn2.ix.netcom.com>

Try to select from dba_objects
the procedure should appear in that view

Winnie

Jacques Sireude wrote in message <6ns2o0$f02$1_at_news.rain.org>...
>Hi,
> What is the sql statement to know if a procedure does exists in the
>database?
>
>Thanks for any help.
>
>Jacques.
>
>---------------------------------------------------------------------------
-
>----------------
>Jacques SIREUDE
>6585 PICASSO Rd Apt#3
>ISLA VISTA CA 93117
>USA
>tel/fax: 1-805-685-9208
>e-mail: sireude_at_eiffel.com
> jacques.sireude_at_enst-bretagne.fr
>http://www-eleves.enst-bretagne.fr/~sireude
>---------------------------------------------------------------------------
-
>----------------
>
>
>
Received on Mon Jul 06 1998 - 22:26:55 CDT