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: 10677
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: exchange partition help
Next Topic: Variable passing please explain difference between T-SQL and PL/SQL
Goto Forum:

Current Time: Wed Aug 23 12:46:55 CDT 2017

Total time taken to generate the page: 0.05017 seconds