ADO 2.5 and returning recordsets from Oracle cursors 
Author Message
 ADO 2.5 and returning recordsets from Oracle cursors

Help

We have been running Oracle stored procedures with an output cursor and 2
input parameters. e.g.

PROCEDURE MYPROCEDURE(v_ReturnCur OUT Cur, v_Code IN Varchar2 , v_Period IN
Varchar2)

We have been removing the cursor parameter before we execute and return the
results to a temporary recordset. This has worked fine with ADO 2.1.

After upgrading to ADO 2.5 this fails! It works with stored procedures which
return a cursor and have 1 input parameter. Does anyone know why and are
there any work around without changing lots of code.

Thanks
Jude Bly



Sat, 15 Mar 2003 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ADO 2.5, Oracle REF CURSOR

2. HOW TO: ADO 2.5 Oracle Stored Proc into Recordset

3. ADO - OLE DB Oracle ( REF Cursors as Return-Value)

4. Problem with ADO 2.5 and dynamic cursors not updating

5. ADO, OLE DB and Oracle - can't addNew to recordset, wrong cursor type

6. ADO Recordset -> Oracle 8i Cursor

7. Oracle REF CURSOR into ADO Recordset

8. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL

9. Oracle ODBC (Native) and Visual Basic ADO 2.5 Timeouts and Hanging Clients

10. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

11. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

12. Errors # returned from ADO 2.5

 

 
Powered by phpBB® Forum Software