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.

Do you have more than one trigger on this table?
Try to disable all your triggers or remove them from the table.

Did you try to run the update through SQL Plus or with remote views
or SQL pass through or what?


>Thanks for your advice.
>As a matter of fact I did not use those column names, I took these only as an example.
>
>With your suggested update statement in the trigger I get another error message :
>Connectivity error, ORA-04091 : table MYTABLE is being updated and is not allowed to be approached by a trigger function.
>
>What else can I try to do?
>TIA
>Peter.