Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: update triggers to update same table
If I understand what you asked...
During the PLSQL Block of the UPDATE trigger, if you only fiddle with the contents of the current row, then this will not cause another UPDATE trigger to occur.
Hth,
Randy
Wim Derweduwe wrote:
>
> We have a table with a key1, key2, figure1, calcul1 fields.
>
> What I want to do is an update trigger that when a row is updated or a new
> one is inserted that it calculates the calculated field calcul1 dpending
> on other row in that table.
>
> But what happens? As the lines is updated oracle starts the trigger and
> updates the calculated field, so the row is again updated and it starts
> again the trigger or is that a wrong consumption?
>
> Wim
Received on Thu Oct 07 1999 - 15:38:10 CDT