Xref: alice comp.databases.oracle:75127 comp.databases.oracle.misc:35530 comp.databases.oracle.server:56356
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newshub.northeast.verio.net!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: drobinson1@my-deja.com
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle,comp.databases.oracle.server
Subject: Procedures and functions within packages
Date: Wed, 07 Jul 1999 14:46:17 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 17
Message-ID: <7lvp7l$ega$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Jul 07 14:46:17 1999 GMT
X-Http-User-Agent: Mozilla/4.07 [en] (WinNT; I ;Nav)
X-Http-Proxy: 1.0 x22.deja.com:80 (Squid/1.1.22) for client 199.222.100.4

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.

Thanks.


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