Discovering Stored Procedures?

[John Puopolo]

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

[Brian Peasland]

The information you need can be found in ALL_PROCEDURES, ALL_ARGUMENTS,
and maybe ALL_SOURCE, depending on what you are looking for.

HTH,
Brian

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

--
===================================================================

Brian Peasland
oracle_dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

[John Puopolo]

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@exxesolutions.com> wrote in message news:<3F02F9F2.91013CA1@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.