log_packet_to_host

CREATE TABLE log_packets_to_host (
         action            VARCHAR2(32) DEFAULT '',
         action_date       DATE,
         action_user       VARCHAR2(256)        DEFAULT '',
         action_module     VARCHAR2(256)        DEFAULT '',
         action_host       VARCHAR2(256)        DEFAULT '',
         pack_id           INTEGER);

CREATE OR REPLACE TRIGGER insert_packets_to_host
AFTER  INSERT  ON packets_to_host
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
 INSERT INTO log_packets_to_host
 (
   action,action_date,action_user,action_module,action_host,pack_id
 )
 VALUES('INSERT',today(), SYS_CONTEXT ('USERENV', 'OS_USER'), SYS_CONTEXT ('USERENV', 'MODULE'),
        SYS_CONTEXT ('USERENV', 'HOST'),:NEW.pack_id);
END insert_packets_to_host;
/

CREATE OR REPLACE TRIGGER delete_packets_to_host
BEFORE DELETE  ON packets_to_host
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
 INSERT INTO log_packets_to_host
 (
   action,action_date,action_user,action_module,action_host,pack_id
 )
 VALUES('DELETE',today(), SYS_CONTEXT ('USERENV', 'OS_USER'), SYS_CONTEXT ('USERENV', 'MODULE'),
        SYS_CONTEXT ('USERENV', 'HOST'),:old.pack_id);
END delete_packets_to_host;
/