Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!tdsnet-transit!newspeer.tds.net!sn-xit-02!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.misc Subject: Re: PL/SQL: Identifying package in which a procedure or function is found Date: Mon, 02 Feb 2004 11:49:42 -0800 Organization: ATS Message-ID: <1075751324.167901@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <88f8c6ea.0401210929.5ef65cbb@posting.google.com> <88f8c6ea.0402021109.48bc07f@posting.google.com> In-Reply-To: <88f8c6ea.0402021109.48bc07f@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 43 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:135260 Ken Ho wrote: > Scott Mattes wrote in message news:... > >>hoke@gse.harvard.edu (Ken Ho) wrote in >>news:88f8c6ea.0401210929.5ef65cbb@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@x.washington.edu (replace 'x' with a 'u' to reply)