Oracle PL/SQL Tutorial/System Tables Data Dictionary/user method params

Query user_method_params

   <source lang="sql">

SQL> SQL> select distinct method_name, type_name from user_method_params order by type_name; --</source>