Re: determine cursor parameter name of a stored procedure

On Sat, 20 Mar 2004 20:58:04 +0100, Philipp Sumi <nospam_at_123123123.xxx> wrote:

>Hello newsgroup
>
>I'm working on an open source data access framework for the .NET
>platform (http://dao.sourceforge.net). To support Oracle along with
>stored procedures, I need to determine the name of the cursor parameter
>that returns retrieved data at runtime.
>
>I guess there is a way to get the parameters (or even specific
>parameters) of a stored procedure which can be further inspected to
>finally determine the name of the cursor parameter.
>
>...I hope that was not too vague :-)
>
>Thanks for your advice
>
>Philipp
>
>
>
>
>
>Example: I need to get the name "Cursor" from the procedure below...
>
>CREATE OR REPLACE PROCEDURE RETRIEVEFARM (Cursor IN OUT
> PIGFARM_PACKAGE.FarmCursor,
> FarmIdentifierParam IN NUMBER)
>
>IS
>BEGIN
> OPEN Cursor FOR SELECT * FROM PERSISTENCEEXAMPLE_FARM WHERE
> FARMIDENTIFIER = FarmIdentifierParam;
>
> [...]
>END RETRIEVEFARM;
check out user_|all_|dba_arguments

Using a reserved word as formal parameter is of course hideous practice.

--
Sybrand Bakker, Senior Oracle DBA