How to get list of all the procedure inside a package oracle

Question

Can I get the name of all the function inside a package. Suppose I have a package PKG_OWA and I want to list all the procedure inside the package.

Answer 1

The data dictionary view ALL_PROCEDURES (or USER_PROCEDURES if you just want your packages). Find out more.

 select procedure_name  from all_procedures  where owner = 'YOU'  and object_name = 'YOUR_PACKAGE' 

---

This lists the public procedures exposed in the package specification. There is no easy way of retrieving the private procedures (that is, those specified only in the package body) except by processing the source text. Oracle do provide a utility PL/SCOPE which we can use to gather this information, but it requires us to change session settings and recompile our code, so it may not be suitable in all situations. Find out more.

Answer 2

I use this one:

your package:

SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'PACKAGE'      and owner = 'owner_name'     and object_name = 'package_name' 

your procedures (only from specs, i.e. global):

select *  from all_procedures  where owner = 'owner_name'  and object_name = 'package_name' 

and in/out arguments from procedure:

select *  from ALL_ARGUMENTS  where owner = 'owner_name'     and package_name = 'package_name'     and object_name = 'procedure_name' 

enjoy!