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

How about querying dba_procedures/all_procedures

Quoting Guang Mei <GMei_at_ph.com>:

> 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
>
>

--
http://www.freelists.org/webpage/oracle-l