Trigger: Update the table which fires the trigger?
Date: Thu, 14 Feb 2008 06:56:31 -0800 (PST)
I created an
BEFORE UPDATE OF column list ON table FOR EACH ROW trigger in an 10g instance.
In the body I am trying to update an other column of the same table
which is fireing the trigger.
The trigger is compiled an valid. When the trigger is fired I got ORA-04091: "...A trigger (or a user defined PL/SQL function that is referenced in this statement) attempted to look at (or modify) a table that was in the middle of being modified by the statement which fired it."
This I understand but I want to do the extra Update as well. Is there a way?
A hint would be highly appreciated. Thanks!
Carsten Received on Thu Feb 14 2008 - 08:56:31 CST