Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get a list of procedures/functions in a package?

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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/06/02
Message-ID: <3392cc8f.1147209@newshost>#1/1

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

http://govt.us.oracle.com/ -- downloadable utilities



Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US