Is there any way to find package name of a given procedure in oracle 11g

Question

Is there any way to find package name of a given procedure in oracle 11g.

regards, Tarak

Answer 1

You can use the USER_PROCEDURES view as it contains the package name in the OBJECT_NAME column and procedure within it in the PROCEDURE_NAME column for records having OBJECT_TYPE = 'PACKAGE'.

Use the following query:

SELECT OBJECT_NAME AS PACKAGE_NAME,
       PROCEDURE_NAME
  FROM USER_PROCEDURES
 WHERE OBJECT_TYPE = 'PACKAGE'
   AND PROCEDURE_NAME = 'YOUR_PROCEDURE_NAME';