Xref: alice comp.databases.oracle:75128 comp.databases.oracle.misc:35541 comp.databases.oracle.server:56365
Path: alice!news-feed.fnsi.net!news.he.net!newsfeed.berkeley.edu!newsfeed.stanford.edu!paloalto-snf1.gtei.net!news.gtei.net!inet16.us.oracle.com!not-for-mail
From: clbeck@us.oracle.com (Christopher Beck)
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle,comp.databases.oracle.server
Subject: Re: Procedures and functions within packages
Date: Wed, 07 Jul 1999 15:33:48 GMT
Organization: Oracle Corp.
Lines: 37
Message-ID: <378571e2.8699699@inet16.us.oracle.com>
References: <7lvp7l$ega$1@nnrp1.deja.com>
Reply-To: clbeck@us.oracle.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: inet16.us.oracle.com 931361658 20056 138.1.120.248 (7 Jul 1999 15:34:18 GMT)
X-Complaints-To: usenet@inet16.us.oracle.com
NNTP-Posting-Date: 7 Jul 1999 15:34:18 GMT
X-Newsreader: Forte Agent 1.5/32.451

On Wed, 07 Jul 1999 14:46:17 GMT, drobinson1@my-deja.com wrote:

>I need to read at runtime the names of procedures and functions that are
>within a PL/SQL package (and their parameter types, if possible).  So
>far I have been able to extract metadata about tables and views by
>looking at Oracle's built-in views such as ALL_TABLES and
>ALL_TAB_COLUMNS, but I have not been able to do the same for packages.
>For packages, the ALL_SOURCE table contains the source code, but does
>not give any specific information about the contents of the package.
>Does anyone know if there are any Oracle tables that will give me this
>information (I don't want to have to write a utility to parse the actual
>source code!).  Otherwise, if there is a downloadable PL/SQL utility
>that can extract that information, please point me to the URL.

Look at the all_arguments table.



hope this helps.

chris.

>
>Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.


--
Christopher Beck
Oracle Corporation
clbeck@us.oracle.com
Reston, VA.
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation