Sybrand Bakker wrote:
> 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
Note: There is no dba_arguments ... only user_ and all_.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Mar 21 2004 - 13:55:04 CST
