Re: HOW to retrieve Oracle SP Paramters

plivingstone_at_statestreet.com wrote:
> Hi,
>
> I want to retrieve a list of the stored procedures for a schema (or
> owner) then retrieve for wach one a list of all the parameters,
> parameter types (IN OUT etc) and the data types.
>
> Is there a special ORACLE stored proc for that in ORACLE 9i
>
> thanks,
>
> Philip

No need for a stored procedure.

desc all_arguments

If the object is part of a package ... object_name is the name of the function or procedure in the package.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org