Re: Getting Dependcies on Package functions ?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 12 Oct 1999 08:53:49 -0400
Message-ID: <HS8DOJCM2kpJ80XvIK=+xkRO9R0M@4ax.com>

A copy of this was sent to Matthias Barmeier <barmeier_at_mamba.com> (if that email address didn't require changing) On Tue, 12 Oct 1999 08:52:06 +0200, you wrote:

>Hi,
>
>
>I found the USER_DPENDENCIES table really usefull, but cannot see any
>posibility to get dependency information concerning package functions.
>
>Is there another table or view where I can get this Information ?
>
>
>Ciao
> Matthias
>

No, things on dependent on standalone functions and procedures, packages, views, tables and so on.

Things are not dependent on a function within a package -- they are dependent on the package itself. thats the only level to which we track these things.

--
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 Tue Oct 12 1999 - 07:53:49 CDT