Isn't that function of DBMS_DESCRIBE.DESCRIBE_PROCEDURE? http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_descrb .htm Mindaugas Navickas OCP DBA From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ethan Post Sent: May 31, 2006 9:41 PM To: GMei@xxxxxx Subject: Re: how to get function/procedure name and type in a package You can parse out the functions and procedure names in packages from all_source. You will need to write some crafty SQL but it isn't really that hard. - Ethan