Home » Developer & Programmer » Precompilers, OCI & OCCI » Rollback statement closes cursor
Rollback statement closes cursor [message #93911] Tue, 25 March 2003 07:24 Go to next message
Nitin Patil
Messages: 1
Registered: March 2003
Junior Member

I am running pro*c code which issues rollback/commit depending on status of set of records , whenever a rollback is issued by code , rollback closes the cursor and then it gives error:
"fetch out of sequence".
This happens randomly

can ane 1 tell that why does rollback closes the cursor. ???
*)The select statement is simple select statement without for update clause.

what is the solution for this.
Re: Rollback statement closes cursor [message #93928 is a reply to message #93911] Sat, 12 April 2003 03:07 Go to previous messageGo to next message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

If you use MODE=ANSI, Oracle will close all cursors when you issue a COMMIT or ROLLBACK. Use MODE=ORACLE if you want to keep cursors open across transactions.

Best regards.

Re: Rollback statement closes cursor [message #94140 is a reply to message #93911] Tue, 30 March 2004 03:36 Go to previous message
Kaustubh Deshpande
Messages: 32
Registered: March 2004
Hi Nitin,

Have you written ROLLBACK RELEASE ?

what is the statement u have written.

Previous Topic: Simple One
Next Topic: Basics of Pro*C
Goto Forum:

Current Time: Sun Mar 03 02:15:54 CST 2024