I have a realy annoying problem...
here is the code...
if the trigger finds a row, it is not allowed to delete, the message is displayed and the triggeractions are rolledback...Code:CREATE OR REPLACE TRIGGER RechtMgrDel BEFORE DELETE ON benrecht FOR EACH ROW BEGIN if :old.gname<>'--' then RAISE_APPLICATION_ERROR(-20901,'dont do it!'); end if; END; / SHOW ERROR;
I want the triger to delete the rows, which are allowed to delete
and to leave the rows, which are not allowed to delete..