Return Parameter list for an Oracle procedure 1

Try:



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

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)

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



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

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