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

[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

[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.