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