Get ready to write your own code ... this is not documented anywhere AFAIK, I have been looking for it since 1997. Raj --- Mike Schmitt <mschmitt@xxxxxxxxxxxx> wrote: > > > Hi all, > > dba_dependencies tells us which tables that a package touches. However, a > package might consist of 20 separate procedures. We have been asked to find > out what tables each procedures of a package reference. > > for example: > > test.proc1 references tables: emp, department, region > test.proc2 references tables: emp > test.proc3 references tables: region, department > > Thanks for the help > ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------