SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Howe to retrieve Dependencies??

419019Sep 13 2006 — edited Oct 3 2006

Hi All,
I have a number of procedures, functions and packages. I want to retrieve all the dependent tables for each pro/pkg and for each table display the type of transaction done (select/update/delete)
ex:
i want something like:

Object Dependencies Transactions
Proc1 Tab1 Insert/Update
Tab2 Select
Tab3 Delete

Is there any way how can i retrieve this info? Or any tool where i can download?

Thnks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2006

Added on Sep 13 2006

6 comments

607 views