Re: Mutation Error for Update Trigger [message #1824] |
Mon, 03 June 2002 01:54 |
JoJo
Messages: 18 Registered: January 2002
|
Junior Member |
|
|
i think your problem is that your trying to update the table on which the trigger is fired,which is impossible.You cannot acces the table on which the trigger is fired except for the :new and :old values.
If you try to update this table,you ll get a mutating table error.
if you want to update your table,try to use a before update trigger and
:NEW.columnname1 := value;
:NEW.columnname2 := value2;
|
|
|