SQL错误: ORA-00904: "OPER_DATE_TIME": 标识符无效 - 解决方法

SQL: merge into SYSMN.SYS_OPERATION_APPLY t1 using ( ( select ? as OPERATION_APPLY_ID, ? as OPERATION_ID, ? as REQ_USER_ID, ? as REQ_DATE_TIME, ? AS REQ_STATUS, ? as OPER_STATUS, ? as OPER_USER_ID, ? as REMARK from dual ) ) t2 on (t1.OPERATION_APPLY_ID = t2.OPERATION_APPLY_ID) when matched then update set GMT_MODIFY = sysdate ,DATA_VERSION = to_char(to_number(t1.DATA_VERSION)+1), OPERATION_ID = t2.OPERATION_ID,REQ_USER_ID = t2.REQ_USER_ID, REQ_DATE_TIME = t2.REQ_DATE_TIME,REQ_STATUS= t2.REQ_STATUS,OPER_STATUS = t2.OPER_STATUS , OPER_USER_ID = t2.OPER_USER_ID, OPER_DATE_TIME = sysdate,REMARK = t2.REMARK when not matched then insert (OPERATION_APPLY_ID, DATA_VERSION, GMT_CREATE,GMT_MODIFY, HOSPITAL_ID, OPERATION_ID,REQ_USER_ID,REQ_DATE_TIME,REQ_STATUS,OPER_STATUS,OPER_USER_ID,OPER_DATE_TIME) VALUES (sys_guid(), '1', sysdate, sysdate,'80D024E29BF40C9DE0537A5B14AC1620', t2.OPERATION_ID,t2.REQ_USER_ID,sysdate,t2.REQ_STATUS,t2.OPER_STATUS,T2.OPER_USER_ID,sysdate)

Cause: java.sql.SQLException: ORA-00904: 'OPER_DATE_TIME': 标识符无效

这个错误是由于SQL语句中使用了无效的列名'OPER_DATE_TIME'导致的。请检查表结构，确保该列名存在。