Skip to Main Content
Forums

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!

List Public and Private Procedures

lynwodeJul 7 2008 — edited Jul 7 2008
Hi,
I'm trying to get list of all our procedures/functions from our packages. I have managed to get all the public ones using the following query, however I am stuck on how to get the private ones.

SELECT object_name, procedure_name FROM all_procedures WHERE owner = 'XXXX'
ORDER BY object_name, procedure_name

Any help would be appreciated

Cheers,
Tim
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2008
Added on Jul 7 2008
5 comments
614 views