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

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

Other related posts: