Re: ODP.NET Ref Cursor Input to oracle Stored Procedure

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@xxxxxxxxx> wrote in message
news:1181585481.592090.200550@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Reporting with dynamic sql
    ... In Oracle you *don't* need temporary tables. ... What you need is a REF CURSOR. ... variable cur REF CURSOR ... Sybrand Bakker, Senior Oracle DBA ...
    (comp.databases.oracle.misc)
  • Re: newbie passing parameters from Web page to Stored Procedure
    ... I think it is in my First SQL statement. ... I'm using Oracle 9i. ... CREATE OR REPLACE PACKAGE pkgpending AS ... What you likely want to do is return a REF CURSOR. ...
    (comp.databases.oracle.server)
  • Re: .NET & Oracle Ref Cursor
    ... change the SQL statement). ... >> I am creating a service that uses an Oracle backend. ... >> using something that Oracle refers to as a ref cursor. ... >> How does .NET return a stored procedure that uses a ref ...
    (microsoft.public.dotnet.faqs)
  • Re: passing in list of values in stored procedure
    ... modified the procedure here to use REF CURSOR - applicable in Oracle ... not just lists as is evident from this example. ... back to .net programs and jdbc programs. ...
    (comp.databases.oracle.server)