CREATE OR REPLACE TRIGGER tzl060_cpckcx_trigger
   AFTER UPDATE
   ON twl090_cpxsckd
   FOR EACH ROW
DECLARE
   v_ckdbh   CHAR (11);
   v_cplsh   NUMBER (8);
   v_bz      CHAR (1);

   CURSOR cur_ckdcx
   IS
      SELECT   t130.ckdbh,
               CASE
                  WHEN COUNT (*) * t015.mbxzs <>
                         (SELECT SUM (xssl)
                            FROM twl130_cpxsckd_mx
                           WHERE ckdbh = t130.ckdbh AND cplsh = t130.cplsh)
                     THEN '1'
                  ELSE '0'
               END bz,
               t130.cplsh
          --into v_ckdbh,v_bz,v_cplsh
      FROM     twl130_cpxsckd_mx t130 JOIN tzl052_ckcptbjl t052
               ON t052.ckdlsh = t130.ckdlsh
               LEFT JOIN tzl003_cpz t003 ON t003.cptbbh = t052.cptbbh
               LEFT JOIN tzl041_ctbjl t041 ON t041.cptbbh_new = t052.cptbbh
               JOIN tqj015_cpdmb t015 ON t015.cplsh = t130.cplsh
         WHERE t130.ckdbh = :OLD.ckdbh
      GROUP BY t130.ckdbh, t130.cplsh, t015.mbxzs;
BEGIN
   IF :NEW.zt = '1'
   THEN
      OPEN cur_ckdcx;

      LOOP
         FETCH cur_ckdcx
          INTO v_ckdbh, v_cplsh, v_bz;

         EXIT WHEN cur_ckdcx%NOTFOUND;                --少了退出条件,会死循环

         DELETE FROM tzl060_cpckcx2
               WHERE ckdbh = v_ckdbh AND cplsh = v_cplsh;

         INSERT INTO tzl060_cpckcx2
                     (ckdbh, cplsh, bz
                     )
              VALUES (v_ckdbh, v_cplsh, v_bz
                     );
      END LOOP;

      CLOSE cur_ckdcx;
   -- commit;触发器中不能提交
   END IF;
END;

------解决方案--------------------
1. 正常的触发器不会有事务控制语句，触发器中修改的内容由与外部事务统一处理。
2. loop循环没有退出的语句，估计会死循环。


------解决方案--------------------
表级的触发器中是不能出现commit的，
只有数据库级事务触发器是可以commit的。