SQL 命令未正确结束

### The error may exist in URL [/mappers/addInfoMapper.xml]

### The error may involve fv.dao.AddInfoMapper.calcOutsideData-Inline

### The error occurred while setting parameters

### SQL: WITH TABLEA AS        (SELECT COUNT(*) YXSL FROM ys_dhb06@yt dhb06 WHERE RQ = to_date(?, 'yyyy-MM-dd') AND SCSJ > 0 AND EJDWDM IN(SELECT REGEXP_SUBSTR(?,'[^,]+',1,rownum) FROM dual connect by rownum <= LENGTH(?) - LENGTH(REGEXP_REPLACE(?,',')) + 1) AND NOT EXISTS(        SELECT ORGNA_ID FROM SYS_ORG sorg WHERE PARENT_ID IN(SELECT REGEXP_SUBSTR(?,'[^,]+',1,rownum) FROM dual connect by rownum <= LENGTH(?) - LENGTH(REGEXP_REPLACE(?,',')) + 1) AND sorg.ORGNA_ID = dhb06.DWDM)),        TABLEB AS        (SELECT COUNT(*) ZZTTSL,NVL(SUM(RZQL),0) TTZQL FROM ys_dba03@YT dba03 WHERE RQ = to_date(?, 'yyyy-MM-dd') AND ZQJLB = '吞吐注汽' AND SCSJ > 0 AND EXISTS(        SELECT JH,JH1,JH2 FROM (        SELECT JH,JH1,JH2 FROM ys_dhb06@yt dhb06 WHERE RQ = to_date(?, 'yyyy-MM-dd') AND SCSJ > 0 AND EJDWDM IN(SELECT REGEXP_SUBSTR(?,'[^,]+',1,rownum) FROM dual connect by rownum <= LENGTH(?) - LENGTH(REGEXP_REPLACE(?,',')) + 1) AND NOT EXISTS(        SELECT ORGNA_ID FROM SYS_ORG sorg WHERE PARENT_ID IN(SELECT REGEXP_SUBSTR(?,'[^,]+',1,rownum) FROM dual connect by rownum <= LENGTH(?) - LENGTH(REGEXP_REPLACE(?,',')) + 1) AND sorg.ORGNA_ID = dhb06.DWDM))    jhs WHERE dba03.JH = jhs.JH OR dba03.JH = jhs.JH1 OR dba03.JH = jhs.JH2)),        TABLEC AS        (SELECT COUNT(*) ZZQQSL,NVL(SUM(RZQL),0) QQZQL FROM ys_dba03@YT dba03 WHERE RQ = to_date(?, 'yyyy-MM-dd') AND ZQJLB = '汽驱注汽' AND SCSJ > 0 AND EXISTS(        SELECT JH,JH1,JH2 FROM (        SELECT JH,JH1,JH2 FROM ys_dhb06@yt dhb06 WHERE RQ = to_date(?, 'yyyy-MM-dd') AND SCSJ > 0 AND EJDWDM IN(SELECT REGEXP_SUBSTR(?,'[^,]+',1,rownum) FROM dual connect by rownum <= LENGTH(?) - LENGTH(REGEXP_REPLACE(?,',')) + 1) AND NOT EXISTS(        SELECT ORGNA_ID FROM SYS_ORG sorg WHERE PARENT_ID IN(SELECT REGEXP_SUBSTR(?,'[^,]+',1,rownum) FROM dual connect by rownum <= LENGTH(?) - LENGTH(REGEXP_REPLACE(?,',')) + 1) AND sorg.ORGNA_ID = dhb06.DWDM))    jhs WHERE dba03.JH = jhs.JH OR dba03.JH = jhs.JH1 OR dba03.JH = jhs.JH2)),        TABLED AS        (SELECT (NVL(YXSL,0) - NVL(ZRYXSL,0)) DBYXSL,(NVL(ZQL,0) - NVL(ZRZQL,0)) DBZQL        FROM        (SELECT YXSL,ZQL FROM SCYX_RDZQ WHERE RQ = to_date(?, 'yyyy-MM-dd') AND DWMC= ? AND AZMS = '外部' AND FWMS = '内部') a,        (SELECT YXSL ZRYXSL,ZQL ZRZQL FROM SCYX_RDZQ WHERE RQ =        (SELECT TRUNC(to_date(?, 'yyyy-MM-dd') - 1) RQ FROM DUAL) AND DWMC = ? AND AZMS = '外部' AND FWMS = '内部'))        SELECT * FROM TABLEA,TABLEB,TABLEC,TABLED;

### Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束

在Mapper.xml文件中，语句末尾多加了 ";"