Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: list of parameters for a procedure

Re: list of parameters for a procedure

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Thu, 02 Aug 2001 13:13:01 -0400
Message-ID: <7d2jmtog3bsivkioti90b42fl1spb3mkvf@4ax.com>

Sure. You get it the same way you get the columns for a table - with the DESCribe command.

desc procedure_name

On 2 Aug 2001 07:55:27 -0700, sirvin_at_synomics.com (Simon Irvin) wrote:

>Is it possible to obtain a parameter listing for a procedure from the
>database? I have found the user_source view which lists the pl/sql.
>Has anyone written a procedure to decode this?
>
>Thanks in advance for any help.

--
Chuck Hamilton
chuck_hamilton_at_yahoo.com

"Do not be deceived, God is not mocked; 
for whatever a man sows, this he will also
reap." (Gal 6:7 NASB)
Received on Thu Aug 02 2001 - 12:13:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US