Is there a workaround for the 'mutating table' problem in a trigger ?
From: <coolcat_at_citynet.net>
Date: 1996/04/11
Message-ID: <4ki28r$1oi_at_news.citynet.net>#1/1
Date: 1996/04/11
Message-ID: <4ki28r$1oi_at_news.citynet.net>#1/1
Hi
In a trigger on a table, I want to do a
SELECT MAX() ...
from that table and update a denormalized column in another table.
However, the table obviously mutates.
Does ORACLE ?
TIA. Received on Thu Apr 11 1996 - 00:00:00 CEST