EAS报无效 SQL 语句
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-00900: 无效 SQL 语句
原代码:
String sql="update T_FIN_Loan set CFReceiptDate=sysdate where fid ='"+sourceBillId+"'";
ISQLExecutor remoteInstance = SQLExecutorFactory.getRemoteInstance(sql);
remoteInstance.executeSQL();
sql放在查询编辑器运行没有错,但是用代码执行却报“无效 SQL 语句”,去数据库查看执行结果反而执行成功了,原因在于没有进行try catch,改正后如下:
String sql="update T_FIN_Loan set CFReceiptDate=sysdate where fid ='"+sourceBillId+"'";
try {
ISQLExecutor remoteInstance = SQLExecutorFactory.getRemoteInstance(sql);
remoteInstance.executeSQL();
} catch (Exception e2) {
// TODO: handle exception
}