存储程序在navicat里测试过了 没有问题
XML代码
<select id="YD_ML" parameterType="java.util.Map" statementType="CALLABLE">
{call YD_ML(
#{FBEGDATE,mode=IN,jdbcType=VARCHAR},
#{FENDDATE,mode=IN,jdbcType=VARCHAR},
#{PK_ORG,mode=IN,jdbcType=VARCHAR}
)}
</select>
报错代码
2019-04-20 21:05:41,745 DEBUG [modules.demo.dao.ImUserDao.YD_ML] - ==> Preparing: {call YD_ML( ?, ?, ? )}
2019-04-20 21:05:41,756 DEBUG [modules.demo.dao.ImUserDao.YD_ML] - ==> Parameters: '2019-01-01 00:00:00'(String), '2019-01-31 00:00:00'(String), '"01","0101"'(String)
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束
ORA-06512: 在 "NC65.YD_ML", line 11
ORA-06512: 在 line 1
存储过程第11行是一行注释 有大佬知道是为什么吗
好像是单引号的问题 改了之后不报错 但是查不到数据
修改后的代码
map.put("FBEGDATE","2019-01-01 00:00:00");
map.put("FENDDATE","2019-01-31 00:00:00");
map.put("PK_ORG","'''01''',''0101'''");
控制台
2019-04-20 23:22:25,250 DEBUG [modules.demo.dao.ImUserDao.YD_ML] - ==> Preparing: {call YD_ML( ?, ?, ? )}
2019-04-20 23:22:25,270 DEBUG [modules.demo.dao.ImUserDao.YD_ML] - ==> Parameters: 2019-01-01 00:00:00(String), 2019-01-31 00:00:00(String), '''01'',''0101'''(String)