Re: Stored Procedures and Packeges

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 07 Apr 2001 08:57:39 -0700
Message-ID: <3ACF38F3.AB180886@exesolutions.com>

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_at_esalab.it
>
> Thank you
>
> Alessandro Rodilosso
Received on Sat Apr 07 2001 - 10:57:39 CDT