Hello,
I am inserting a data into the table through SQL LOADER , during insertion time i have a requirement to insert a duplicate record on the sametable.
I have written the below trigger but its failing with the below error. Please advise.
CREATE OR REPLACE TRIGGER DUP_DATA
AFTER INSERT
ON XX_USER_DATA
FOR EACH ROW
BEGIN
INSERT INTO XX_USER_DATA
(
VNAME
,v_site
)
VALUES
(:NEW.V_NAME,:NEW.v_site);
END;
ERROR
ORA-04091: table XX_USER_DATA is mutating, trigger/function may not see it
ORA-06512: at "APPS.DUP_DATA", line 3
ORA-04088: error during execution of trigger 'APPS.DUP_DATA'