The "pragma autonomous_transaction" keeps this from happening. The
other problem is that while the user updates one record with a
particular keyfield (name), I need to calculate all records that have
the same value in the keyfield (name).
Mark D Powell wrote:
>
> When you call a procedure from a database table trigger you normally
> pass the procedure the row data that it is to work with. If you try to
> work with the table that the trigger is defined on then you will likely
> end up with a "mutating table" error.
>
> HTH -- Mark D Powell --
Received on Tue Dec 19 2006 - 10:06:07 CST
