1.

How Can A Transaction Be Retried After An Exception?

Answer»

The following method can be used to RETRY a transaction after an exception is raised:

  • The transaction should be written within a sub-block
  • The sub-block can be placed inside a LOOP that repeats the transaction.
  • Mark a SAVEPOINT before starting the transaction. If the transaction SUCCEEDS, then COMMIT and exit from the loop. If the transaction fails, the control is transferred to the exception handler where the transaction is rolled back to the savepoint to undo the changes, and then try to fix the problem.

The following method can be used to retry a transaction after an exception is raised:


Discussion

No Comment Found

Related InterviewSolutions