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

Moderator: admin

Post Reply
javabean68
Posts: 29
Joined: Wed Mar 16, 2016 8:38 am
Contact:

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

Post by javabean68 » Thu May 04, 2017 6:55 am

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
Site Admin
Posts: 8297
Joined: Fri Sep 10, 2010 9:26 pm
Contact:

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

Post by admin » Thu May 04, 2017 10:06 am

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