Re: Discovering Stored Procedures?

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_at_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"