Willy Klotz wrote:
>
> If my infomation is correct, then a package will get status INVALID if
> a table which is used by the package is droped or modified. The same
> goes for a procedure which is called by another procedure / package.
>
> So, there must be some information how packages, procedures and
> function depend on each other.
>
> Does anyone know in which views/tables this information is stored ?
>
> What I am trying to do is make a "graph" of the several (hundred)
> packages in our database, so one can see which thing calls what...
>
> Willy
> Willy Klotz
>
> ======================================================================
> Willys Mail FidoNet 2:2474/117 2:2474/118
> Mailbox: analog 06297 95035
> ISDN 06297 910105
> Internet: willyk_at_t-online.de
> -> No Request from 06.00 to 08.00 <-
> ======================================================================
The views ALL_DEPENDENCIES, DBA_DEPENDENCIES and USER_DEPENDENCIES will
give you the information.
Received on Tue Nov 12 1996 - 00:00:00 CST
