More records after FETCH FIRST???

From: Andrei Romazanov <ierdna_at_web.de>
Date: Tue, 4 Nov 2003 20:38:27 +0100
Message-ID: <bo8v7n$1bhrfe$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
.....

EOF - 10 records found

no commit / rollback !
And now again:

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

EOF - 91 records found???!!!

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

Thanks in advance
Andrei Received on Tue Nov 04 2003 - 13:38:27 CST