-----Original Message-----
From: usha ponniah [mailto:usharam22@h...]
Sent: 27 August 2000 15:40
To: support@w...; feedback@w...
Subject: question about "Returning recordset from oracle to VB using REF
CURSOR


Hi,

Book Title : Visual Basic Oracle 8 Programmer's Reference.
Author     : John Mason & Dov Trietsch.


My name is Usha Ponniah. I recently purchased "Visual Basic Oracle 8 
programmers guide".I was looking for 'how to return recordsets from oracle
database to visual basic through stored procedure (chapter 13)using REF 
CURSOR. The method described in the book was simple and easy to 
understand.
I have a question about, if the recordset returned from oracle is empty 
(ie)
no recordset is returned, When I tried to exeute this statement "set objrs 

objcmd.execute",I got an error "fetched cursor returns null". I cannot use
objrs.eof or objrs.bof beause when i try to execute the above statement 
itself, the error occurs. I would like to know how do you handle this 
situation in VB.

If you have any sample code for the above situation mentioned , please 
send
me.

Kindly reply and appreciate your help.


Usha Ponniah.
Email: usharam22@h...
usha.ponniah@e...