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

Moderator: admin

Post Reply
Posts: 31
Joined: Wed Mar 16, 2016 8:38 am

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

Post 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!

Site Admin
Posts: 9389
Joined: Fri Sep 10, 2010 9:26 pm

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

Post 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.
If you like our products and services, please help us by posting your review here.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests