Re: Mutating Table Insert Situation

From: <phil.webb_at_health.wa.gov.au>
Date: 1998/03/24
Message-ID: <6f9m3p$2m3$1@nnrp1.dejanews.com>#1/1

In article <6f8i5i$1os$1_at_nnrp1.dejanews.com>, drpaner_at_intrex.net wrote:

> 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 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!
>

>

I think that we get around this by using the Oracle Job Scheduler to Schedule a Procedure that will handle the command the problem causing SQL (in your case the inserts to the detail table). Write your proposed inserts to a temporary table and have the scheduled process wake up every 5 minutes; check for records in the temporary table and then write and delete them. This is a little 'asynchronous' but should get over your problem.

Phil Webb

-----== 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