Mutating Tables...how to handle..?
From: Michael Joseph <qmick_at_nyc.pipeline.com>
Date: 1996/04/25
Message-ID: <4lp0kc$eoa_at_pipe9.nyc.pipeline.com>#1/1
Date: 1996/04/25
Message-ID: <4lp0kc$eoa_at_pipe9.nyc.pipeline.com>#1/1
Does anyone know the best way to deal with this...?
I have a row level trigger that fires AFTER I insert a new record in table
A to insert a set of child rows in the child table B which of course has a
Foreign Key constraint defined to A.
The trigger fires and returns the message 'Table A is Mutating any changes
What a pain....
Thanks for the help...