Using Oracle.ClientAccess.Data with System.Data.Common

G

Guest

I am trying to return a datatable using the Oracle driver. In order to return
a dataset from the stored proc I need a cursor type to receive the data. How
is this possible with the Common namespace since it does not have a cursor or
refcursor type?

John
 
C

Cowboy \(Gregory A. Beamer\)

REF CURSOR = DataTable in Microsoft ADO.NET. This is an oversimplification,
of coruse. When using the Oracle driver, you need to specify the REF CURSOR
as an output param in your ADO.NET code. If you use OLEDB, you do not, as it
is automagically done for you. Fun,eh?

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think Outside the Box!
*************************************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem filling Strongly Typed DataSet from an Oracle 9i stored procedure that returns multiple ref 2
EnterpriseLibrary. Return Recordset from oracle stored procedure 2
ORA-24338 and REFCURSOR 1
REF CURSOR returns no rows 5
System.OutOfMemoryException in DataAdapter 4
DbProviderFactory, System.Data.Common, huh? 1
Multi select stored proc and strongly typed data sets 1
How to get cursor as return value of oracle function back with ole 4

Top