Home » Other » General » How to get list of StoredProcedures names of a given user in Oracle and it's parameter (oracle 10i)
icon5.gif  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 Go to next message
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?
Re: How to get list of StoredProcedures names of a given user in Oracle and it's parameter [message #351928 is a reply to message #351916] Fri, 03 October 2008 13:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
user_arguments

Regards
Michel
Re: How to get list of StoredProcedures names of a given user in Oracle and it's parameter [message #351932 is a reply to message #351928] Fri, 03 October 2008 14:13 Go to previous message
taclejj
Messages: 2
Registered: October 2008
Location: Guadalajara, Mexico
Junior Member

Thank you very much, i will try that.
Previous Topic: Delete the files with the particular extension upto some days i.e., older ones
Next Topic: 10g Installation
Goto Forum:
  


Current Time: Thu Dec 08 16:07:32 CST 2016

Total time taken to generate the page: 0.10947 seconds