FETCH FIRST in the same cursor -> more records???

From: Andrei Romazanov <ierdna_at_web.de>
Date: Wed, 5 Nov 2003 12:29:35 +0100
Message-ID: <boamuv$17e6vs$1@ID-70985.news.uni-berlin.de>

Hi @all!

I use Dynamic SQL in my C-programm (linux + ORACLE 8.1.7). It makes the approximately following:

SELECT .....
FETCH FIRST
some actions without database access
FETCH NEXT
some actions without database access
FETCH NEXT
.....

End of recordset - 10 records found

no commit / rollback !
And now again:

FETCH FIRST (in the same cursor, without new SELECT!) some actions: SELECT, UPDATE, ...
FETCH NEXT
some actions: SELECT, UPDATE, ...
FETCH NEXT
.....

End of recordset - 91 records found???!!!

any idea? Can an other process affect the record count in this situation?

Thanks in advance
Andrei Received on Wed Nov 05 2003 - 05:29:35 CST