ORACLE minus sql injection violation, minus not allow 该怎么解决

select corp_id from lv_insr_topay where calc_prd = :end_date and topay_type = 1 and insr_detail_code=:insr_detail_code 

minus 

select corp_id from lv_insr_topay where calc_prd = :start_date and topay_type = 1 and insr_detail_code=:insr_detail_code


这个sql语句报错  请问该怎么办

评论区

静态代码块

2018-05-09 17:28

你贴个异常信息啊

lqwqc987

2018-05-09 17:29

@静态代码块 com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: sql injection violation, minus not allow

静态代码块

2018-05-09 17:31

sql语句是使用占位符吗? 不是占位符的话值+ '值' 试试

热门反馈

扫码入社