TRIGGER BEFORE UPDATE

Hallo to who is looking at this,

I must set the value of the columne "status" to 'C' ("Changed") as soon as an other column has been updated. My trigger

CREATE OR REPLACE TRIGGER htbvz

       BEFORE UPDATE ON table
       FOR EACH ROW WHEN (new.bvz = 'Y')
       BEGIN
             UPDATE table SET status='C' WHERE :new.bvz='Y';
       END;

does not work since the table is mutating, that is being modified by the update. How can one do this simple thing?

Thanks for any help, Wolf Kammer Received on Tue Dec 17 1996 - 00:00:00 CST