Re: Trigger question
From: Kuresh <k_kapadia_at_hotmail.com>
Date: Wed, 17 Jan 2001 05:30:09 -0000
Message-ID: <t6abf1e58eqr5c_at_corp.supernews.com>
Date: Wed, 17 Jan 2001 05:30:09 -0000
Message-ID: <t6abf1e58eqr5c_at_corp.supernews.com>
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/Received on Wed Jan 17 2001 - 06:30:09 CET