SQL 命令未正确结束

作者: AdamSun19 | 来源:发表于2019-07-31 22:34 被阅读0次

SQL 命令未正确结束
oracle之> ORA-00933: SQL 命令未正确结束
ORA-00933: SQL 命令未正确结束
MySQL 存储过程
mysql学习笔记（四）
MySQL学习笔记（五）存储过程
mysql的注意项总结
MySql数据库基础概述
SQL常用命令书目录
mysql 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文件中，语句末尾多加了 ";"