A procedure loops through a table and updates each record in a begin / end block. The update sometimes fails due to unique key violation. With having an exit or an continue handler the record to be updated is DELETED! With an undo handler everything is as expected.
After my opinion deleting the record in such cases is unacceptable.
Log in to post a comment.