Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> functions / procedures in packages

functions / procedures in packages

From: Willy Klotz <willyk_at_t-online.de>
Date: 1996/11/11
Message-ID: <566chv$o19@news00.btx.dtag.de>#1/1

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 <-
======================================================================
Received on Mon Nov 11 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US