July 7th, 2004, 03:58 AM
Join Date: Jul 2004
Time spent in forums: < 1 sec
Reputation Power: 0
Before Delete Trigger
I have a realy annoying problem...
here is the code...
CREATE OR REPLACE TRIGGER RechtMgrDel
BEFORE DELETE ON benrecht
FOR EACH ROW
if :old.gname<>'--' then
RAISE_APPLICATION_ERROR(-20901,'dont do it!');
if the trigger finds a row, it is not allowed to delete, the message is displayed and the triggeractions are rolledback...
I want the triger to delete the rows, which are allowed to delete
and to leave the rows, which are not allowed to delete..