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
Hi,

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: 4579
Registered: April 1998
Senior Member
Hi,

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.

Frank
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
Member
Hi Nitin,

Have you written ROLLBACK RELEASE ?

what is the statement u have written.

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


Current Time: Fri Mar 29 08:28:49 CDT 2024