Re: Triggers and table mutation

Use the stmt level trigger. If you need to know the orginal data values, you can store it in a pl/sql table in the row trigger.

Frank W Phillips JR schrieb:

> I need to write an update trigger on a table but the trigger may need to
> update and/or insert additional records into the same table. Obviously
> this is not natively supported, the infamous table mutating error. Any
> ideas on how to handle this?
Received on Wed May 06 1998 - 22:49:25 CEST