Re: list of parameters for a procedure

From: Simon Irvin <sirvin_at_synomics.com>
Date: 3 Aug 2001 01:20:41 -0700
Message-ID: <24174c27.0108030020.2edae706@posting.google.com>

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.

I have now found the user_arguments view which presents the infomration as a results set. Just what I needed.

Thanks for the replies

Simon Irvin Received on Fri Aug 03 2001 - 03:20:41 CDT