Re: How to know if a procedure exists?

From: <karmit_at_my-dejanews.com>
Date: Tue, 07 Jul 1998 19:06:51 GMT
Message-ID: <6ntrkb$t8u$1@nnrp1.dejanews.com>

Try these:

select 'X'
from all_objects
where object-name='MYPROC'
and owner='PROCOWNER'
and object_type='PROCEDURE'

select distinct name
from all_source
where type = 'PROCEDURE'
and owner='PROCOWNER'

By selecting user/all/dba_source you can see the procedure PL/SQl code. Karmit

In article <6ns2o0$f02$1_at_news.rain.org>, "Jacques Sireude" <sireude_at_eiffel.com> wrote:
>
> 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
> ----------------------------------------------------------------------------
> ----------------
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jul 07 1998 - 14:06:51 CDT