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!

How can I find all tables in a give stored procedure in the package

user60022Mar 31 2011 — edited Mar 31 2011

Hi All,

I think dba_dependenices can be used to find all tables in the standalone stored procedures or all tables in the pacakge.

But how can I get the tables in the pacakged SP?

I am not allowed to create any SP in this enviroment, so it's not feasible to change packaged stored procedure to standalone one.

Best regards,
Leon

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2011

Added on Mar 31 2011

3 comments

320 views