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.
Can anybody quide me the right direction.
RE: Return Parameter list for an Oracle procedure
Try:
CODE
----------------------------------------------------------------------------
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
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.
----------------------------------------------------------------------------
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