Re: determine cursor parameter name of a stored procedure

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:p6bp50de3jo1phi3j8qasom2h5ekotu39d_at_4ax.com...
| 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

i think that's just example code, sybrand

philipp, how do you need to get the parameter name? dynamically at runtime? in your interface? or in PL/SQL code

you may be able to use the info in the all_arguments data dictionary view

;-{ mcs Received on Sat Mar 20 2004 - 16:46:13 CST