Re: OLD NEW value in trigger ?

> i have another question about 'mutating table'
> in before insert trigger on A
> i had select count(*) from A where A.col = :new.col;
> which generated 'mutating table' error
> and i changed it to where i use before/after trigger and package
> select count(*) from A where A.col = frompackage.col;
> and this one worked.
>
> so 'mutating table' error wasn't raised by 'querying on A'
> what's going on here?
>
> thanks a lot in advance

in row triger you cannot use select.

if you have too, store all needed values in temporary table (row triger), and then launch select from statement trigger.

MZ Received on Tue Sep 17 2002 - 10:50:58 CDT