Re: Discovering Stored Procedures?

Gents:

Much obliged. Thank you.

John

PS
What books/docs do you recommend that I read for similar info? Going to Oracle on-line is too confusing as there are vast amounts of info. Thx.

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3F02F9F2.91013CA1_at_exxesolutions.com>...
> 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.
Received on Mon Jul 07 2003 - 02:12:16 CEST