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
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?

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.
Previous Topic: Can we access Enterprise Manager of 10g server from 9i client?
Next Topic: Logging Key Values during FGA
Goto Forum:

Current Time: Wed Oct 26 17:04:49 CDT 2016

Total time taken to generate the page: 0.09438 seconds