Hi,
I am getting below error in trigger
Error ORA-04091: table PORTAL.PARTNER_LOCATIONS is mutating, trigger/function may not see it ORA-06512: at "PORTAL.AUDIT_PARTNER_LOCATIONS_TRG", line 7 ORA-04088: error during execution of trigger 'PORTAL.AUDIT_PARTNER_LOCATIONS_TRG'
create or replace TRIGGER AUDIT_PARTNER_LOCATIONS_TRG
AFTER INSERT OR UPDATE ON PARTNER_LOCATIONS
FOR EACH ROW
DECLARE
L_ID NUMBER;
L_STATUS VARCHAR2(1000);
BEGIN
SELECT ID, STATUS INTO L_ID, L_STATUS FROM PARTNER_LOCATIONS WHERE ID = :NEW.ID;
IF L_STATUS = 'DEAUTHORIZED' or L_STATUS = 'TERMINATED' THEN
INSERT INTO AUDIT_PARTNER_LOCATIONS_STATUS VALUES (L_ID, L_STATUS);
END IF;
END;
Please suggest me how to fix this error
Thanks
Sudhir