Am a sql developer and new to oracle, i was assinged a trigger for
am having two tables
Table1 : Test
Cols : ID | DESC
Cols : MID | STATUS
and i want a update in third table "S_ID" when an insert | Delete | Udpate happends on Table1.
Table3 : SID
Cols : M_ID | STATUS
CREATE OR REPLACE TRIGGER TRG_TEST
AFTER INSERT OR UPDATE OR DELETE
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
UPDATE S_ID SET STATUS ='Y'
WHERE SID in
(SELECT SID FROM TEST_CUST WHERE M_ID=:old."ID");
But am gettting error "A mutation table is defined as a table that is changing"
need your help please...