Xref: alice comp.databases.oracle.server:24155
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!sunqbc.risq.qc.ca!carnaval.risq.qc.ca!not-for-mail
Message-ID: <35A236C6.4C61A352@usa.net>
From: doid <doid@usa.net>
Reply-To: doid@usa.net
X-Mailer: Mozilla 4.04 [en] (Win95; U)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: How to know if a procedure exists?
References: <6ns2o0$f02$1@news.rain.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
Date: Tue, 07 Jul 1998 14:50:19 GMT
NNTP-Posting-Date: Tue, 07 Jul 1998 10:50:19 EDT

I usually use something like this:

  1  select *
  2  from all_objects
  3  where object_name like '%TIME%'
  4* and object_type = 'PROCEDURE'

Jacques Sireude wrote:

> Hi,
>     What is the sql statement to know if a procedure does exists in the
> database?