
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!