...
The transaction handler is used for errors in DDL and during commit/rollback.
The update handler also covers LOB operations.
The "NO_DATA" and "TOO_MANY" handler is used only once for a conflict – if using this handler leads to a conflict again, "Error" handler is used for the next attempt. For the next change SQL, the Data conflict will be used again.
Additionally, logging may be specified:
...