Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: Identifying package in which a procedure or function is found

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

From: Scott Mattes <Scott_at_TheMattesFamily.ws>
Date: Wed, 21 Jan 2004 18:10:39 GMT
Message-ID: <Xns9477861073820ScottatTheMattesFami@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 = '' Received on Wed Jan 21 2004 - 12:10:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US