determine cursor parameter name of a stored procedure

From: Philipp Sumi <nospam_at_123123123.xxx>
Date: Sat, 20 Mar 2004 20:58:04 +0100
Message-ID: <c3i7oa$rsa$1@newshispeed.ch>

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; Received on Sat Mar 20 2004 - 13:58:04 CST