Rollback in a trigger
421820May 21 2004 — edited May 21 2004Using a trigger on update.
In the code for the trigger I want to do the following:
Update a table in another database on the same server using a database link.
Update a table in another database on a remote server using a database link.
Delete the row that is currently being updated.
If any errors occur, I have:
EXCEPTION
WHEN OTHERS
THEN ROLLBACK
The idea is that if any of the three actions fail, then an exception will occur and the previous actions would roll back.
If I take down the remote server, I would expect that the error handling would come into play. ItÂ’s not. The changes on the local database have occurred. Am I doing something wrong, flawed logic?