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
About Question enthuware.oce-jpad.v6.2.361 :
Moderator: admin
-
- Posts: 31
- Joined: Wed Mar 16, 2016 8:38 am
- Contact:
-
- Site Admin
- Posts: 10068
- Joined: Fri Sep 10, 2010 9:26 pm
- Contact:
Re: About Question enthuware.oce-jpad.v6.2.361 :
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.
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.
Who is online
Users browsing this forum: No registered users and 87 guests