Re: help with triggers and mutating tables

On 15 May 2007 09:48:28 -0700, heidi <heidistettner_at_gmail.com> wrote:

>The problem is not in any individual update in the trigger. I can
>update the relevant columns by themselves and the trigger fires fine.
>The problem is when I try updating both columns in one statement.
>Only the first update in the trigger will fire.

That may be, but your unformatted code is completely unreadable. Do you assume anyone else is going to format it for you?

-- 
Sybrand Bakker
Senior Oracle DBA