CREATE OR REPLACE TRIGGER BLOQ_DEL_TRABNECECOMPWEB BEFORE DELETE ON TRABNECECOMP FOR EACH ROW
DECLARE V_IDTRABNECECOMPWEB VARCHAR2(1);
BEGIN
   IF NVL(:OLD.IDTRABNECECOMPWEB, 'N') = 'N' THEN
      DELETE FROM TRABNECECOMPWEB WHERE NRNECECOMPWEB = :OLD.NRNECECOMPWEB;
   END IF;
END;
/