Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: table mutating error in trigger

Re: table mutating error in trigger

From: Mal Heseltine <mth_at_qld.mim.com.au>
Date: 1997/03/14
Message-ID: <3328EB81.972@qld.mim.com.au>#1/1

You could trap the mutating table error.

Mike Emerson wrote:
>
> Is there any way to select from the table which fired the trigger in a
> row based trigger? I get a table mutating error when I try this. I
> can understand getting this error if I try to modify the record which
> fired the trigger, but this isn't being done.
>
> Mike Emerson
Received on Fri Mar 14 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US