Re: PL/SQL: Identifying package in which a procedure or function is found

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 02 Feb 2004 11:49:42 -0800
Message-ID: <1075751324.167901@yasure>

Ken Ho wrote:

> Scott Mattes <Scott_at_TheMattesFamily.ws> wrote in message news:<Xns9477861073820ScottatTheMattesFami_at_24.48.107.53>...
> 

>>hoke_at_gse.harvard.edu (Ken Ho) wrote in
>>news:88f8c6ea.0401210929.5ef65cbb_at_posting.google.com:
>>
>>
>>>Is there a way to generate the list of all procedures and functions
>>>which are found in packages, including the "owning" package for each?
>>>
>>
>>Yes.
>>
>>Depending on your release level you can try
>>
>>select *
>>from sys.all_arguments
>>Where owner = ''
>>And package_name = ''

> 
> 
> Thanks, I'm on 8.1.7.  Your query is an interesting way of using
> arguments to discern which non-standalone procedure or non-standalone
> function is inside which package.  It will understandably not find
> procedures or functions that lack arguments, but can still be useful.
> 
> If anyone has other ideas for more directly identifing the package
> which "owns" a procedure or function, I'll appreciate them.

The "Yes" is only valid if you are referring to publicly declared procedures and functions.

Procedures and functions local to the package body can not be cataloged except by reading the code.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Feb 02 2004 - 13:49:42 CST