Re: list of parameters for a procedure

From: <dnabbott_uk_at_yahoo.co.uk>
Date: 3 Aug 2001 04:40:40 -0700
Message-ID: <9e962c67.0108030340.5aa94032@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.

Or you can look in the all_arguments view. This shows the arguments for each procedure (and for each procedure in a package) - very useful when you forget the exact name of a procedure that is in a package as you can do a LIKE query to find it! Received on Fri Aug 03 2001 - 06:40:40 CDT