Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get a list of procedures/functions in a package?
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
![]() |
![]() |