Skip to Main Content

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 to list referenced objects in package body

jerry44Sep 1 2016 — edited Sep 3 2016

Hi, I have few packages and every package consists of set of functions and procedures. I'd like to list functions, procedures, tables and views referenced within functions and procedures stored in selected packages (f.e. test_package - test_package.function1 - referenced functions  - a(x) return varchar2,b(x) return number, etc, in general list divided in sub list of object for every function/procedure in package, so i know that packege function/procedure references to listed objects). How I can do it?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2016
Added on Sep 1 2016
7 comments
1,219 views