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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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!
*************************************************
 
Back
Top