Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: list of parameters for a procedure
sirvin_at_synomics.com (Simon Irvin) wrote in message news:<24174c27.0108020655.1c1f1965_at_posting.google.com>...
> 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.
Simon:
You'd be better off parsing the output of a DESCRIBE of the procedure thus:
DESC proc_name;
Hope this helps. Received on Thu Aug 02 2001 - 16:18:06 CDT