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

Thanks!

I can't find views named user_arguments nor all_arguments (using 7.2, maybe a script we haven't run), but using argument$ and user_objects solves my problem.

Best Regards,

Jarle Stabell

Thomas Kyte <tkyte_at_us.oracle.com> 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.
Received on Mon Jun 02 1997 - 00:00:00 CDT