1、T_MONTHLY_TARGET 表 在使用 设置变量命令 可以执行,且 查询出来的接口是null
2、使用sql语句执行出来的结果,却是 表 不存在,使用sql语句命令执行的sql为:
SELECT CREATER as sqr,COMPANY as sqgs,substr(DEPARTMENT,2) as sqbm, to_char(SYSDATE,'yyyy-mm-dd') as sqrq, to_char("YEAR",'yyyy') AS "YEAR","MONTH", TASKS_NUMBER AS rwsl FROM T_MONTHLY_TARGET WHERE IS_DELETE = 0 AND IS_OLD_VERSION = 0 AND MONTHLY_TARGET_CODE =:targetCode
错误日志显示如下:
|