System.Data.OleDb Oracle Ref Cursor into Dataset

[Henry]

Hello,

Can someone please provide me with a working code sample (PL/SQL, VB.NET or
C#) on how to retrieve a out ref cursor from an Oracle 8 database to an
ASP.NET DataSet.

Thank you in advance.

Henry Yeng

 

[Robert Bruckner [MSFT]]

Did you read the following article on MSDN? At the bottom of the article you
will find a section about Oracle REF cursors with sample code for populating
a DataSet:
http://msdn.microsoft.com/library/d...-us/cpguide/html/cpcontheadonetdatareader.asp

 

[mboizeau]

Here you will find a c# sample to connect to an oracle Database with
oledb:
http://oraclevsmicrosoft.blogspot.com/2004/12/connect-net-application-to-oracle.html
(scroll dow to see the code. Easy to compile with csc.exe.)

hope this helps!

oraclevsmicrosoft