[archive] Rollback / Read Nnext

[Migrated content. Thread originally posted on 14 January 2005]

I'm testing Acucobol 6.2.0.1 in a AIX 5.2L on a Oracle 9I database in the 64-bit mode using Acucobol 4GL, and everytime I do a "rollback"(Oracle one or with Acucobol transaction) followed by a "read next" the result it's an "ORA-01002 - Fetch out of sequence", does anyone knows why this appens and what is the soluction ?


Thx in advance.

I do not use Acu4GL, so I can't explain what it is doing, but...

With most databases, a commit or rollback of a transaction closes all open cursors opened on that connection. So it sounds like Acu4GL was using a cursor and the rollback closed the cursor, then the simulated READ NEXT tried to get a row from the cursor and it can't because it is closed.

Just a guess though...

[Migrated content. Thread originally posted on 14 January 2005]

I'm testing Acucobol 6.2.0.1 in a AIX 5.2L on a Oracle 9I database in the 64-bit mode using Acucobol 4GL, and everytime I do a "rollback"(Oracle one or with Acucobol transaction) followed by a "read next" the result it's an "ORA-01002 - Fetch out of sequence", does anyone knows why this appens and what is the soluction ?


Thx in advance.

Yeah ! You're right, but the same program with an Oracle 8.1.7,32 -bits doesn't have the same problem.