Skip to Main Content
Forums

Oracle Database Discussions

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!

Tables used by a procedure in a package

513463Feb 15 2010 — edited Feb 25 2010
Hi Gurus,
I have a package, and a procedure inside that package is accessing some tables and interacting with some other functions lets say...

In general dependencies of tables can be found using user_dependencies view, and I tried the same even for my scenario, but failed.

But if I try to find dependencies for standalone procedure (not embedded into a package), I can find the details.
This is not working for the procedures embedded inside a package.

Please help me if there is any way of knowing those dependencies for my scenario.


Thanks & Regards
RK Veluvali

Edited by: RK Veluvali on Feb 15, 2010 8:34 PM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 25 2010
Added on Feb 15 2010
#general-database-discussions, #procedure
3 comments
752 views