Re: How to get a list of procedures/functions in a package?

Thomas Kyte wrote:
>
> In 7.2 and up there are views
>
> all_arguments
> user_arguments
>
> A query such as:
>
> select distinct package_name, object_name
> from user_arguments
> where package_name = 'Whatever'
>
> Will generate such a list. In earlier releases, you can look at the sys owned
> table argument$ to get the same info but you'll have to do the joins yourself to
> resolve the package names and datatypes.
>
>
> On 2 Jun 1997 11:54:14 GMT, "Jarle Stabell" <jarle.stabel_at_dokpro.uio.no> wrote:
>
> >Hi,
> >
> >I want to get the list of procedures/functions in a package, and then get
> >the parameter list of each.
> >It seems like one can use 'describe' to do the second half of this task,
> >but we don't know any easy way to get the list of methods in a package.
> >Anyone knows where this is stored? (Which tables do 'describe' use?)
> >
> >Best Regards,
> >
> >Jarle Stabell
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government
> Bethesda MD

Using SQL Worksheet (not SQL*Plus) you can:

desc package_name

It doesn't always work, eg if you have a package with the same name as a schema.

Cheers,

Finn

-- 
--------------------------------------------------------------------------------
 Finn Ellebaek Nielsen          Oracle Associated Senior Consultant
 Ellebaek Consulting            E-mail:           ellebuk_at_post3.tele.dk
 Niels Ebbesens Vej 9, 3. th.   Mobile Phone:     +45 20 32 49 25
 DK-1911  Frederiksberg C       Mobile Phone SMS: 20324925_at_sms.tdm.dk (Subject)
 Denmark                        Private Phone:    +45 33 25 34 50
--------------------------------------------------------------------------------
 "Life is a beach and then you dive"                      "Divers do it deeper"