The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Friday, January 25, 2008

Procedure and Function in a Package

You can use following query to find procedures and function names defined in a Package:

select distinct object_name from all_arguments where package_name = 'package_name';

To find the entire source you can use:
select text from user_source WHERE type = 'PACKAGE' and name='package_name';

No comments: