Triggers (original) (raw)

CREATE OR REPLACE TRIGGER trig_ins_ord_det
AFTER INSERT
ON ord_det
FOR EACH ROW
BEGIN
INSERT INTO audit_ord_det VALUES(seq_audit_ord_det.nextval, :new.orden_id, 'INSERT', CURRENT_DATE);
END trig_ins_ord_de;
/

CREATE OR REPLACE TRIGGER trig_upd_ord_det
AFTER UPDATE
ON ord_det
FOR EACH ROW
BEGIN
INSERT INTO audit_ord_det VALUES(seq_audit_ord_det.nextval, :old.orden_id, 'UPDATE', CURRENT_DATE);
END trig_upd_ord_det;
/

CREATE OR REPLACE TRIGGER trig_del_ord_det
AFTER DELETE
ON ord_det
FOR EACH ROW
BEGIN
INSERT INTO audit_ord_det VALUES(seq_audit_ord_det.nextval, :old.orden_id, 'DELETE', CURRENT_DATE);
END trig_del_ord_det;
/