Home » SQL & PL/SQL » SQL & PL/SQL » Need dependent details
Need dependent details [message #208846] Tue, 12 December 2006 06:15 Go to next message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member
Hi all,
I have package called pack1, inside this i'm having many procedure like proc1, proc2 and etc. sometime within these procedure i'm calling outside procedure like out_proc1, out_proc2 and etc. At each procedure i'm refering multiple tables.

when i query all_dependencies, i could see only the tables which is being used inside the package, however i could not see the tables which is being used outside procedure.
how we can achieve it?

Thanks,
Thangam
Re: Need dependent details [message #208852 is a reply to message #208846] Tue, 12 December 2006 06:23 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please see if this works.
I beleive With a little tweak you can get what you want.
http://www.orafaq.com/forum/m/173973/42800/?srch=pratapz#msg_173685
Previous Topic: Can we access Enterprise Manager of 10g server from 9i client?
Next Topic: Logging Key Values during FGA
Goto Forum:
  


Current Time: Sat Dec 03 04:09:21 CST 2016

Total time taken to generate the page: 0.10116 seconds