Discussion Board

Savepoints Yes, we can use savepoint before each function begins. Savepoints are similarly useful in application programs. If a procedure contains several functions then you can create a savepoint before each function begins. Then, if a function fails, it is easy to return the data to its state before the function began and re-run the function with revised parameters or perform a recovery action. After a rollback to a savepoint, Oracle releases the data locks obtained by rolled back statements. Other transactions that were waiting for the previously locked resources can proceed. Other transactions that want to update previously locked rows can do so. Prajakta Pandit 02-19-2017 10:53 PM

Write your comments