Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> functions / procedures in packages
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.deReceived on Mon Nov 11 1996 - 00:00:00 CST
-> No Request from 06.00 to 08.00 <-
======================================================================