Preventing record deletion with “INSTEAD OF DELETE” triggers
643309Jun 9 2008 — edited Jun 9 2008Preventing record deletion
I have to migrate an MS SQL 2005 database to an ORACLE 9i database. In MS SQL we use “INSTEAD OF DELETE” triggers on tables to prevent record deletion. Instead of a delete we perform an update. Changing the application code is not an option.
According to the ORACLE documentation instead of triggers can only be applied to views.
I tried using a simple BEFORE DELETE trigger to raise an application error to prevent the deletion, but the application cannot handle the exception raised. And even if the application could handle the raised exception. I would still have to perform a update.
Question: What is the equivalent for an instead of delete trigger on a table in ORACLE 9i? (Specific do an update instead of delete)