Re: table is mutating

Matthias Gresz wrote:
>
> Hi folks,
>
> for all those fighting with 'table is mutating' - errors in for each row
> triggers, a solution from german oracle support:
>
> Take something like this as cursor:
>
> select ...
> from your_table
> where
> your_where_clause
> and :new.rowid != rowid;
>
> --
> Regards
>
> Matthias Gresz :-)

Hi,

it only works with insert triggers.

-- 
Regards

Matthias Gresz    :-)