Re: Novel scenario of trigger mutation - take a look

From: Kim Hughes <Kim=Hughes%NA%Contractors_at_bangate.compaq.com>
Date: 1996/01/15
Message-ID: <DL8HJJ.AIK_at_twisto.eng.hou.compaq.com>#1/1


Badri,

   Oracle has it so any action on the table the trigger is firing for causes a mutating table condition. This is because the state of the table is not know to the trigger. It is not based at the row level it is based at the table level. Row locking does not apply to this scenario.

D. Kim Hughes
DRT Systems
Houston, TX 77008
(713)868-5537 ext: 312 Received on Mon Jan 15 1996 - 00:00:00 CET

Original text of this message