Re: table mutating error in trigger

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

In a row based trigger, it's impossible to select from the table which which fired the trigger. They are several solutions to solve this constraint, depending what you search to do. Nead more informations to help you.

Eric Wuillai Received on Sat Mar 15 1997 - 00:00:00 CST