Accessing Oracle Ref cursor with Ole DB provider for Oracle

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Cedric FABIOUX (FABIOUX_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 09:15:01 -0800

Hello,

I'd like to know, if it is possible, how I could access a ref cursor,
returned by an Oracle stored procedure, in my VB.net application using the
OledbCommand component.
My problem is that the type "OracleType.Cursor" isn't available for the
Oledb command, so I don't know wich type I can use for my OUTPUT parameter
that receive the Cursor.

Thank you for your help

Cedric FABIOUX

Relevant Pages

  • Ruby sample code for PLSQL REF CURSORS
    ... I am having hard time to find a sample that shows me how to return an OUT ... REF CURSOR from my oracle stored procedure to my python program. ...
    (comp.lang.ruby)
  • Returning Xml as text from Oracle Stored Proc
    ... I am returning Xml from an oracle stored procedure using the Oracle managed provider, using a ref cursor to fill a dataset. ... The Xml is stored as a varchar on the database, but when I retrieve it, all newline tab and double quote characters have been escaped. ...
    (microsoft.public.dotnet.framework.adonet)
  • How to get multi ref cursors returned by an Oracle stored procedure?
    ... I have an Oracle stored procedure like the following: ... ref cursor out c2) as ... How can I get these 2 returned cursors and cast them to datasets in Delphi ... Thanks for any clues. ...
    (borland.public.delphi.database.ado)
  • DAAB with Oracle ref cursors
    ... Can anybody send me an example of calling an Oracle stored procedure which returns a ref cursor using Enterprise Library DAAB? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Recordsets and Ref Cursors
    ... I have problem with respect to ref cursor. ... My DB ask me to pass data (about 30 fileds) to oracle stored procedure by ... Jaiganesh ...
    (microsoft.public.dotnet.framework.adonet)