OraFAQ Forum: General » How to get list of StoredProcedures names of a given user in Oracle and it's parameter

Home » Other » General » How to get list of StoredProcedures names of a given user in Oracle and it's parameter (oracle 10i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get list of StoredProcedures names of a given user in Oracle and it's parameter [message #351916]

Fri, 03 October 2008 13:10

taclejj
Messages: 2
Registered: October 2008
Location: Guadalajara, Mexico

Junior Member

Hi I am trying to develope an application that generates required code to access some stored procedures from a oracle db, now I now how to get the procedures, I am using the following query:

SELECT * FROM User_Procedures

and it returns all the procedures, but now I need to know how to get the parameters for a specific stored procedure.

Can any one give the name of the table or how can I get this?

Report message to a moderator