Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

how to get function/procedure name and type in a package

Guang Mei

2006-05-31

Replies:

how to get function/procedure name and type in a package

Is there any view that lists the name of function/procedure  AND IT'S TYPE (function or procedure) in a package? The following query only lists name, but I want the type too.

SQL> select distinct package_name, object_name from user_arguments where PACKAGE_NAME='ACH';

PACKAGE_NAME                   OBJECT_NAME
------------------------------ ------------------------------
ACH                            CHECKRELEASELIMITS
ACH                            DBREQUIRESAPPROVAL
ACH                            GETVALIDEFFECTIVEDATE
ACH                            ISDBEDITOR
ACH                            SETBALANCEDVALIDATOR
ACH                            GETDEFTEFFECTIVEDATE
ACH                            SETACHINCLUSIVELIMITCHECK

7 rows selected.

TIA.
Guang

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.