oracle触发器

CREATE TABLE CONNECTINGBRIDGE (
    TEMP1  VARCHAR(50),
    TEMP2  VARCHAR(50),
    TEMP3  VARCHAR(50),
    TEMP4  VARCHAR(50),
    TEMP5  VARCHAR(50),
    TABLENAME VARCHAR(50),
    flag   VARCHAR(5)
    );




Create Or Replace Trigger CONNECTINGBRIDGETrig
  After Insert Or Delete Or Update On ARC_STOREINFO  For Each Row  
  declare
    d   Number(5);    
Begin
  If Inserting Then
    Insert Into CONNECTINGBRIDGE(TEMP1,flag,TABLENAME) Values (:NEW.STOREID,'0', 'ARC_STOREINFO');
  Elsif Updating Then  
     select count(*) into d from CONNECTINGBRIDGE where TEMP1=:NEW.STOREID;
       if   d   =   0   THEN
       Insert Into CONNECTINGBRIDGE(TEMP1,flag,TABLENAME) Values (:NEW.STOREID,'0', 'ARC_STOREINFO');
    else
       Insert Into CONNECTINGBRIDGE(TEMP1,flag,TABLENAME) Values (:OLD.STOREID,'2', 'ARC_STOREINFO');
    end   if;     
  Elsif Deleting Then
    Insert Into CONNECTINGBRIDGE(TEMP1,flag,TABLENAME) Values (:OLD.STOREID, '1', 'ARC_STOREINFO');
  End If;
End;