Re: Trigger Problem ORA-04091

Did you use the
"before insert or update on <table_name> referencing old as old and new as new"
clause?

Otherwise, I think you can get into the recursive kind of problem.

kal121_at_my-deja.com wrote:

> Hello,
>
> I have a trigger that "should" do the following:
>
> When a table is inserted or updated, it performs a calculation on
> another column in the same table.
>
> However, I have not been able to get this to work. Apparently you
> cannot execute a trigger on a table that is in the process of being
> modified by the statement that called the trigger. If this is true,
> then how am I supposed to do this? I guess I can go back through the
> table periodically and run my calculations manually, or maintain a
> separate table with the calculated column. Both of these options are
> less than ideal, however.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 11 2000 - 00:00:00 CDT