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

From: Mindaugas Navickas <mnavickas_at_yahoo.com>
Date: Wed, 31 May 2006 23:15:31 -0400
Message-ID: <000601c68529$a4283690$6500a8c0@MN>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ethan Post
Sent: May 31, 2006 9:41 PM
To: GMei_at_ph.com
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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 31 2006 - 22:15:31 CDT