I am using 11g Database. I writing the trigger in 3 different tables.
Example Table Name : Table_TRG_1 , Table_TRG_2 , Table_TRG_3
Trigger Name : TRG_Table_TRG_1, TRG_Table_TRG_2, TRG_Table_TRG_3
Examples : Table_TRG_1 -- Insert new records in Table_TRG_1 trigger will fire and insert into the value to Table_TRG_2. (Trigger Name TRG_Table_TRG_1)
Table_TRG_2 --- If insert the new records in this table trigger will fire based on the condition update the few other fields. (Trigger Name : TRG_Table_TRG_2).
Table_TRG_3 --- If some field will update in Table_TRG_2 then record should be deleted in Table_TRG_2 and move it Table_TRG_3.
I am mutating error will occurred. It should be table there is no view and there is like chain process (Automation process.)
Note : Table_TRG_2 Some time insert the new or some time update the particular field then i will raised the trigger :TRG_Table_TRG_2
thanks & Regards
Message was edited by: M.bro