ODP.NET Ref Cursor Input to oracle Stored Procedure

[RCReddyCh]

Hi ALL

I want to send an Input Ref Cursor from .NET to Oracle. The below link
gets the cursor from database as out parameter and sends the same
cursor back as Input which does not make any sense to me.

http://www.oracle.com/technology/oramag/oracle/06-jan/o16odpnet.html

My webservice has the data in xml format with multiple records. I need
to send that data to Oracle with one call using Ref Cursor.

I know, we can send xml to database and parse it but that is not
allowed in our environment!

Any help is greatly apreciated!

Thanks in advance
Ram

 

[Cowboy \(Gregory A. Beamer\)]

He is just showing that you get the output as a REF_CURSOR. This is normal,
as it maps to a DataSet.

Then, he adds a second parameter for the input REF_CURSOR.

The real important part is the version for which it is available, IMO. You
could not pass in REF_CURSOR types prior to this version. Not a big deal, in
most instances, as most sprocs do not take "tables" as inputs. Perhaps not
as true in the Oracle world, but it is rare across the board.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

************************************************
Think outside the box!
************************************************

 

[RCReddyCh]

Greg

It just gets the cursor from DB and sends back the same as Input that
is not practical! I need to send multiple records manupulated in .NET
to Oracle. Oracle provided the feature to send the cursor as input but
if you cannot send the manupulated data from .net to Oracle its of no
use!

Correct me if I am wrong.