table is mutating

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    :-)