Protect record from deletion via trigger
Date: Tue, 1 Jul 2008 08:20:34 -0700 (PDT)
I have a question regarding delete triggers. is there a way to protect one specific record of a table from deletion? The way to do it with a view and instead triggers is not possible. Also i can't raise an APPLICATION_ERROR, since the whole thing should not be visible from application side. Is there a way to do this?
CREATE OR REPLACE
BEFORE DELETE ON TARGETTABLE
FOR EACH ROW
IF (:old.PKCOL=1) THEN
END; Thanks.. :) Received on Tue Jul 01 2008 - 10:20:34 CDT