Is there any way to make it rollback even if I clean exit or abnormal exit.What exits? The client application.
SQL> create table a (a int); Table created. SQL> set autocommit on SQL> insert into a values (1); 1 row created. Commit complete. SQL> rollback; Rollback complete. SQL> select * from a; A ---------- 1 1 row selected.
absriram wrote:If you read carefully thorugh all the previous answers then you might find that this will not solve your problem.
My autocommit is always off.
I am writing some script for script and putting exit rollback in that this is some thing feasible.
Bhargava S Akula.