Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: list of parameters for a procedure
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