I am getting ' mutation table' error in a trigger .
I saw one old similar article of 27th march ,but did not see
the appropriate reply to this question.
I have two tables, I want to put After insert trigger into
table T1 where ........
Select T1.car_ctl_nbr into control_number from T1 ,T2 where
T1.car_init = T2.car_init and
T1.car_nbr = T2.car_nbr ;
Update T2 set car_ctl_nbr = control_number ;
When ever I am inserting one record into T1 , I am getting
mutating table error.
I want this to be done for each row.
Click Here to Expand Forum to Full Width