Mutating Table Insert Situation

Hello all,

I have two tables, a Master and a Detail. There is a foreign key relationship between the two.

When I Update Master records, I have a trigger ( Update, After ) that deletes all of the Detail records and then will attempt to insert new Detail records based on the :NEW. column values.

I am successful in deleting the Detail records, however, when I attempt to Insert into the Detail table, I receive the Mutating Table error.

I am NOT performing any Select statements against either table. Just a simple Insert statement.

I suspect that Oracle performs a Select statement on the Master table behing-the-scenes to verify the foreign key integrity and that is causing the error. I have read the newsgroups buy did not see anyone coming up with this error without performing a Select statement in the trigger.

Does anyone know of a workaround on this? Any help would be greatly appreciated!

Thank you,
Daniel

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Mar 24 1998 - 00:00:00 CST