Hi,
Below is my code. This is for audit purpose. For doing a commit after insert, I included Pragma for this trigger.
But on several searches i found that there is no need of commit inside but it automatically commits..
I am bit confused by studying varyiing posts in forums..
Can somebody give me clarity on this and placement of commit in below trigger body is right ?
I am using 10g version.
CREATE OR REPLACE TRIGGER RESERVE_AUDIT
BEFORE UPDATE ON T_COST
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
IF UPDATING
THEN
INSERT INTO AUDIT_CONTROL
(TYPE,
NO_LU_CONTROL,
CD_FACTOR,
OLD_AMT,
WHO_UPDATED,
LAST_UPDATE)
VALUES
('RES',
:OLD.NO_LU_CONTROL,
:OLD.CD_FACTOR,
:OLD.CLE_AMOUNT,
:OLD.ID_USER,
SYSDATE)
END IF;
COMMIT;
END RESERVE_AUDIT;
Thanks in advance
Prasanth