Recordsets Using ADO and Oracle Stored Procedures 
Author Message
 Recordsets Using ADO and Oracle Stored Procedures

I am having problems when attempting to retrieve records from an ORACLE
stored procedure which utilizes  'reference cursor' for data retrieval.  I
have been able to bind all of the nessecary parameters for the stored
procedure except the 'Cursor Object'.  I don't know which data type to
declare the cursor as, as well as the  direction specified, and the value.
Do I point it to the Dynaset Object?  Oracle has a pre-defined constant
ORATYPE_CURSOR = 102, which is easy to use.  VB does not seem to support
this.

Any help would be greatly appreciated.

Thanks!



Sun, 01 Dec 2002 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. ado recordsets from stored procedures, stored procedures have input parameters

2. Updateable ADO recordset from Oracle Stored Procedure

3. How to return Parameters and Recordset from Oracle Stored Procedure with ADO

4. Oracle stored procedure and input arrays using ADO and VB6

5. Error calling Oracle store procedures using ADO

6. Oracle stored procedures/functions using ADO

7. oracle's stored procedure from vb using ADO

8. executing a stored procedure in oracle using ADO

9. ADO stored procedures from VC++ using ORACLE

10. Unable to get Output data using VB, Ado 2.1 and Oracle Stored procedure

11. HELP ==>Oracle Stored Procedure using ADO(VB)

12. HELP ==>Oracle Stored Procedure(PACKAGE) using ADO(VB)

 

 
Powered by phpBB® Forum Software