Database Trigger

From: Ravindra Basavaraja <ravindra_at_sentica.com>
Date: Wed, 13 Dec 2000 19:47:11 -0000
Message-Id: <10709.124521@fatcity.com>

I am trying to write a database trigger that should fire on update of a table
and when the new value in a column is not equal to 6.

CREATE or REPLACE TRIGGER trg_alt_his_update AFTER INSERT or UPDATE on alt
FOR EACH ROW
   BEGIN

           insert into alt_his
           values(:new.id,:new.status,:new.not,:new.update_time,


           :new.sub) ;

   END; I want this trigger to fire only when the new value of status is not equal to 6.
Where can i put in the WHEN clause.

It doesn't with
insert into alt_his

           values(:new.id,:new.status,:new.not,:new.update_time,


           :new.sub)  WHEN :new.status NOT IN 6;

i get compilation error.

can anyone tell me how to get it work. Received on Wed Dec 13 2000 - 13:47:11 CST