Re: Trigger question

Hi
Yes, becouse the table is mutating.
Solution :
Use package to keep data regarding old, new (from row level before update ) and use statement level trigger .
In this trigger u can use data from the package. bye
Kuresh
Hans Leirvik wrote:
>
>
> I am not able to execute an :
> select sum(colA) from tableA;
> when tableA is the triggering table.
>
> Is this correct ?
> Any workarounds ?
>
> Hans
>
>

--
Posted via CNET Help.com
http://www.help.com/