| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Query for functions and procedures in Package
On Wed, 18 Jun 1997 21:58:09 GMT, jurij.modic_at_mf.sigov.mail.si (Jurij Modic) wrote:
>On Wed, 18 Jun 1997 12:39:29 +0700, Konstantin V Sartakov
><skv_at_kpbank.ru> wrote:
>
>>hi Stephen
>>Stephen Lappin wrote:
>>>
>>> Is there dictionary view available that can be queried to show what
>>> procedures and functions are contained within a Pl/SQL Package?
>>
>>
>> Look at ALL_DEPENDENCIES, DBA_DEPENDENCIES & USER_DEPENDENCIES
>>views.
>
>You won't find what procedures/functions are contained in a package in
>those views. Those views give informations about what objects package
>is dependent on.
>
>I am not aware of any view/table that explicitely lists all procedures
>or functions that exists in packages or package bodies.
>
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.
>Regards,
>
>============================================================
>Jurij Modic Republic of Slovenia
>tel: +386 61 178 55 14 Ministry of Finance
>fax: +386 61 21 45 84 Zupanciceva 3
>e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000
>============================================================
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |