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!

Find All procedures name inside a package

user10316500Jun 17 2019 — edited Jun 17 2019

Hi

Is there a query to find all procedures name inside a package?

I tried with the following statement but it finds only procedures declared inside both Header/Body.

select *

  from dba_procedures

where object_type = 'PACKAGE'

   and object_name = 'xx'

Procedure declared only in the package body are not founded.

Thanks in advance.

Stefano

This post has been answered by Solomon Yakobson on Jun 17 2019
Jump to Answer
Comments
Post Details
Added on Jun 17 2019
5 comments
8,779 views