Re: Trigger Problem ORA-04091

You can not select from a table that's being updated, but it is unlikely you really need the select as all columns are available to the trigger. If you need to update other rows in the same table the generic solution is to buffer the rowids or the primary keys in a pl/sql table and in an after statement level trigger do whatever you need to do. Hence, please post your code so we can determine what needs to be done.

Hth,

Sybrand Bakker, Oracle DBA

<kal121_at_my-deja.com> schreef in berichtnieuws 8cviku$thk$1_at_nnrp1.deja.com...
> 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