×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Return Parameter list for an Oracle procedure

Return Parameter list for an Oracle procedure

Return Parameter list for an Oracle procedure

(OP)
Please forgive me for a pretty basic question but I would like to find the way to determine the paramaters of a an Oracle stored proc by querying the system. I believe there was a stored proc or a function that would provide this information for Oracle 10g but I cannot locate the name of the Oracle proc and cannot find the copy of the code where this was used.
Can anybody quide me the right direction.

RE: Return Parameter list for an Oracle procedure


Try:

CODE

DESC myProcedure 
3eyes

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

RE: Return Parameter list for an Oracle procedure

(OP)
Thank you very much. This worked perfectly when I ran it using the TOAD application.
However, I am not highly skilled using Oracle and am having some trouble using this in a proc.
I want to create a proc which returns the parameter list as a refcursor so an application developed in C# (Visual Studio)can read the parameter names and direction an process an array of values into the appropriate parameters to be passed in to the proc.
I have similar code developed in VB.Net for SQL Server and had deceloped a version some time ago in VB.net to access an Oracle proc so that application part is fine and I know the principle works

But How do I create a proc so this command would ref a ref cursor?
Every idea I have messed with so far will not compile which probaly shows lacl of thought on my part but I am drawing a total blank

The proc I used last time returned a ref cursor already. This proc may have been something developed by that company although I was told at the time it was not (I think, it has been a while)

RE: Return Parameter list for an Oracle procedure


You can also query the {ALL|DBA}_ARGUMENTS View.
noevil

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

RE: Return Parameter list for an Oracle procedure

(OP)
Thanks for the help this is perfect. Sometimes the simplest most basic information is the hardest to find in a goole or Bing search

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close