触发器出错解决方法

触发器出错

SQL code

CREATE OR REPLACE TRIGGER TRG_T_FMSMS  AFTER INSERT OR UPDATE ON T_FMSMS  FOR EACH ROWDECLARE  EXIST_IT NUMBER;BEGIN  SELECT COUNT(*)    INTO EXIST_IT    FROM TASK_EVENT   WHERE TE_STATUSCODE = :NEW.F_CODE;  IF EXIST_IT > 0 THEN  --好像此处有错误，去掉if语块就能编译通过    INSERT INTO TASK_WAIT      ('TW_BYREPORT',       'TW_REPORTFORMAT',       'TW_EMAILFORMART',       'TW_RUNTIME',       'TW_EMAILSUBJECT',       'TW_REFNO')      SELECT TE_BYREPORT,             TE_REPORTFORMAT,             TE_EMAILFORMART,             SYSDATE,             TE_EMAILSUBJECT,             :NEW.F_FID        FROM TASK_EVENT;  END IF;END;