Re: Packages in dictionary ???

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 12 Nov 1999 10:52:20 -0500
Message-ID: <XzcsOCVVnLE0hPIte34Dk09UyN7r@4ax.com>

A copy of this was sent to CC <kkons_at_intrasoft.gr> (if that email address didn't require changing) On Fri, 12 Nov 1999 17:11:52 +0200, you wrote:

>
>
>Hi all,
>
>Could anyone tell me where packages are described in the data
>dictionary?
>I try to find where the procedures' source code is kept.
>
>10q

*_source where * = ALL, USER, or DBA (eg: select * from user_source where name = 'FOO') has the code.

*_arguments has the inputs/outputs of each procedure/function in a table as well.

*_dependencies has the hierarchy of who relies on who (a way to figure out who calls who)

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Nov 12 1999 - 09:52:20 CST