¤ I am sorry for my ignorance but this is new to me. I assume I need a ref
¤ cursor since the Fill method of the Oracle.DataAccess.Client.DataAdaptor will
¤ not take a recordset as a parameter but will take a ref cursor as a
¤ parameter. I will admit to struggling with this issue of trying to make a
¤ VB6 app work with our .Net code. Yes, I am passing the recordset by value
¤ and not by ref. The dataset will be passed into an Oracle stored proc so I
¤ thought it best to use the Oracle.DataAccess.Client.DataAdaptor. The
¤ OleDbDataAdaptor's Fill method does take a recordset as a parameter but I do
¤ not know if I can pass that dataset into the Oracle stored proc.
¤
If you use the native ADO.NET you won't be able to populate an ADODB Recordset directly. There are
two alternatives:
1) Use ADO via interop (with the Command object) and connect via ODBC or OLEDB. This code would
likely be similar to what you have in your VB 6.0 application.
2) Populate a DataSet using the stored procedure and then move the data from the DataSet to the
Recordset. The following MS KB articles may help:
How To Retrieve Multiple Ref_cursors from an Oracle Stored Procedure by Using the .NET Managed
Provider For Oracle
http://support.microsoft.com/default.aspx?scid=kb;en-us;321715
How To Convert an ADO.NET DataSet to ADO Recordset in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;316337
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)