Re: Trigger question

Hans,

  U cannot do this. This is because the table is said to be "mutating"   and in this state, we cannot have any sqls in the trigger trying   to access the same table.

  To solve your requirement, if u are attempting to have a   validation, then use the "statement level" trigger for this and not   the "row level" trigger. U may have to trap the record key in a   temp table which u can access it in the "statement level" trigger   for that table and process it without any problem...

  This should solve your issue...

Regards

In article <93ckij$4rl$1_at_oslo-nntp.eunet.no>,   "Hans Leirvik" <hans.leirvik_at_vianova.no> 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
>
>

--
Regards
Rajagopal Venkataramany


Sent via Deja.com
http://www.deja.com/