oracle触发器加了事务又死锁,oracle执行触发器时报死锁错误

慕慕0277861

CREATE OR REPLACE TRIGGER TRIGGER_ORDERDETAIL

  AFTER DELETE OR INSERT OR UPDATE  ON T_BS_ORDERDETAIL  FOR EACH ROWBEGIN

 IF INSERTING THEN

   UPDATE T_BS_ORDERINFO A SET A.N_ZL=A.N_ZL+:NEW.N_ZL,

                               A.N_TJ=A.N_TJ+:NEW.N_TJ,

                               A.I_ALLCOUNT=A.I_ALLCOUNT+:NEW.I_COUNT    WHERE A.ID=:NEW.I_ID_ORDER;   END IF;   IF UPDATING THEN

     UPDATE T_BS_ORDERINFO A SET A.N_ZL=A.N_ZL-:OLD.N_ZL+:NEW.N_ZL,

                               A.N_TJ=A.N_TJ-:OLD.N_TJ+:NEW.N_TJ,

                               A.I_ALLCOUNT=A.I_ALLCOUNT-:OLD.I_COUNT+:NEW.I_COUNT    WHERE A.ID=:NEW.I_ID_ORDER;     END IF;   IF DELETING THEN

     UPDATE T_BS_ORDERINFO A SET A.N_ZL=A.N_ZL-:OLD.N_ZL,

                               A.N_TJ=A.N_TJ-:OLD.N_TJ,

                               A.I_ALLCOUNT=A.I_ALLCOUNT-:OLD.I_COUNT    WHERE A.ID=:OLD.I_ID_ORDER;     END IF;END;