From: "Daniel A. Morgan" <dmorgan@exesolutions.com>
Newsgroups: comp.database.oracle.server,comp.databases.oracle.misc,comp.databases.oracle.tools
Subject: Re: Stored Procedures and Packeges
Date: Sat, 07 Apr 2001 08:57:39 -0700
Organization: EXE
Message-ID: <3ACF38F3.AB180886@exesolutions.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
References: <9ajqfd$spa$1@pinco.nettuno.it>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yabetcha.drizzle.com!unknown@mud14.drizzle.com
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 29


Amazingly enough you use the DESCRIBE command.

Just: DESC package_name

Daniel A. Morgan

alessandro rodilosso wrote:

> Hi there,
> does anyone know if there's a way to find out
> all infos about implemented stored procedures in
> oracle packages such as
> 1) the listing of all the sp within the package
> 2) the definition of each sp
>
> I'm implementing a tool that must collect a listing of
> the sp within a given schema.
>
> I know there's the package DBMS_DESCRIBE
> but it does not satisfy me for all my needs
>
> I prefer you answer me to this address
>
> a.rodilosso@esalab.it
>
> Thank you
>
> Alessandro Rodilosso