Am having problems accessing the Oracle REF CURSORS using MDAC 2.6/VB.



The procedure is packages and has an output parameter for REF CUROSR. I 

have followed all the code givn in Microsoft. But the recordset always 

returns NULL or no records.



Any help would be appreciated.

How about sharing a code sample?  Could just be a typo or a problem

with a SP declaration.



I pulled my hair out trying to work with Oracle.  I firmly believe

that any money saved in performance is more than shot in developer

anguish :)



So, let's see the problem....



---- Original Message ----

From: gnath@l...

To: activex_data_objects@p...

Subject: RE: [activex_data_objects] MDAC 2.6 accessing REF CURSOR

Date: Wed, 9 May 2001 22:24:03



>Am having problems accessing the Oracle REF CURSORS using MDAC 

>2.6/VB.

>

>The procedure is packages and has an output parameter for REF 

>CUROSR. I 

>have followed all the code givn in Microsoft. But the recordset 

>always 

>returns NULL or no records.

>

>Any help would be appreciated.

>

>

Brian Matsik

President and Senior Consultant

OOCS

-----

Author: ?MCSD Fast Track: Solutions Architecture?, New Riders Press

Co-Author: ?Professional ADO 2.5 Programming?, Wrox Press

Co-Author: ?VBScript Programmer?s Reference?, Wrox Press

Co-Author: ?Professional Visual Interdev 6 Programming?, Wrox Press

Co-Author: ?Professional Access 2000 Programming?, Wrox Press

Co-Author: ?Beginning SQL?, Wrox Press