Re: Discovering Stored Procedures?

John Puopolo wrote:

> All,
>
> I would like to write an application that can obtain the name and
> parameters of a set of stored procedures in an Oracle (9i) database.
>
> Is there a way to programatically enumerate over all stored procedures
> and find out the number, types and direction of parameters that these
> procedures take? Is this information stored in special tables in
> Oracle? I can write the software in C, C++, C# or Java - the client
> is not picky.
>
> BTW, in this scenario, security is not an issue, as my application
> will have been GRANT-ed all the permissions that it needs.
>
> Any help or pointers to proper reading much appreciated. Thank you.
>
> John

Only if you wish to reinvent the wheel.

Everything you want already exists in the data dictionary:

Perform a describe on all_arguments.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)