Page 1 of 1

About Question enthuware.oce-jpad.v6.2.361 :

Posted: Thu May 04, 2017 6:55 am
by javabean68
Hi all,

what does exatly mean 'failure results in only statement-level rollback' vs 'failure results in transaction-level rollback'? Could you explain it by an example?

Thank you very much!
Fabio

Re: About Question enthuware.oce-jpad.v6.2.361 :

Posted: Thu May 04, 2017 10:06 am
by admin
If at any time during execution a SQL statement causes an error, all effects of the statement are rolled back. The effect of the rollback is as if that statement had never been run. This operation is a statement-level rollback.
Given here: https://docs.oracle.com/cd/B10500_01/se ... 7trans.htm

Transaction level is, of course, when all the statements in that transaction are rolled back.