Re: Forceing abort of delete via trigger
Alas, it's not possible in a clean way. Check out this thread:
http://forums.mysql.com/read.php?99,22523
You can force some other, unrelated error (insert a duplicate in your favourite, especially for this purpose created table).
BTW, maybe you can do this with a view WITH CHECK OPTION. You wont get any errors if the conditions are violated, but you can rely on the action to abort.
Edited 1 time(s). Last edit at 08/02/2005 12:36PM by Roland Bouman.
Subject
Views
Written By
Posted
6555
August 01, 2005 02:11PM
Re: Forceing abort of delete via trigger
3713
August 02, 2005 12:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.