Another mutating table problem
From: Jason Boesch <jgboesc_at_REMOVE-THISuswest.com>
Date: Thu, 04 Jun 1998 18:00:15 -0500
Message-ID: <357726FF.1A762F8C_at_REMOVE-THISuswest.com>
I am trying to create a BEFORE INSERT trigger that not only modifies the new record, but also inserts additional records in the triggering table.
Date: Thu, 04 Jun 1998 18:00:15 -0500
Message-ID: <357726FF.1A762F8C_at_REMOVE-THISuswest.com>
I am trying to create a BEFORE INSERT trigger that not only modifies the new record, but also inserts additional records in the triggering table.
I've read some other postings that suggest using a row level trigger to store the current values and then use a statement level trigger to insert the new values. I understand how they work., but I think this problem is different because I'm triggering INSERTs as the result of an INSERT (not an update).
Since the statement level trigger is AFTER INSERT it starts inserting the newly created records over and over again, producing an endless loop and an error.
Any ideas on how this can be done?
Thanks!
-- Jason Boesch jgboesc_at_REMOVE-THISuswest.comReceived on Fri Jun 05 1998 - 01:00:15 CEST