Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

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

Mindaugas Navickas

2006-05-31

Replies:

Message
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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ethan Post
Sent: May 31, 2006 9:41 PM
To: GMei@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
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.