Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table mutating error in trigger
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