Re: functions / procedures in packages

Hi, Willy!

Maybe you could use USER_DEPENDENCIES view.

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 <-
> ======================================================================
 

-- 
Regards. Alexey Neckrasow. Leaves Inc. Russia.