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

  • From: "Mindaugas Navickas" <mnavickas@xxxxxxxxx>
  • To: <post.ethan@xxxxxxxxx>, <GMei@xxxxxx>
  • Date: Wed, 31 May 2006 23:15:31 -0400

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: