Re: Query for functions and procedures in Package

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/06/18
Message-ID: <33aa2c04.15346927@newshost>#1/1

On Tue, 17 Jun 1997 13:45:30 +0100, Stephen Lappin <SL_at_RTEL.co.uk> wrote:

>Is there dictionary view available that can be queried to show what
>procedures and functions are contained within a Pl/SQL Package?
>
>Slainte mhath
>Stephen Lappin
>
>

In 7.2 (forget which 7.2 release supported the views, see below if you don't have these views) 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.   

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 Wed Jun 18 1997 - 00:00:00 CDT