How about querying dba_procedures/all_procedures

Quoting Guang Mei <GMei@(protected)>:

> 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