sql报错，求解答
EAS Cloud-知识分享
金蝶云社区-764600688
764600688
0人赞赏了该文章 729次浏览 未经作者许可，禁止转载编辑于2016年07月08日 08:51:37

执行更新语句，没有结果集的情况下始终提示：Caused exception message is: nullCaused exception message is: ORA-00900: 无效 SQL 语句
sql语句在查询分析器检测过，没有问题
SQL语句如下：
var oppID = otherExpenseBillInfo.getId().toString();
var sql4="update T_BC_OtherExpenseBill set CFIsExport = 1 where FID = '" + oppID + "'";
var sqlExecutor4=new com.kingdee.bos.dao.query.SQLExecutor(sql4);
sqlExecutor4.executeSQL();

具体错误如下：
Caused exception message is: null
Caused exception message is: ORA-00900: 无效 SQL 语句

at com.kingdee.eas.ep.plugin.PluginUtils.getScriptExecuteException(PluginUtils.java:104)
at com.kingdee.eas.ep.plugin.PluginUtils.handleScriptException(PluginUtils.java:62)
at com.kingdee.eas.ep.client.ScriptExecutor.execute(ScriptExecutor.java:43)
at com.kingdee.eas.ep.client.PluginService.executeScript(PluginService.java:189)
at com.kingdee.eas.ep.client.PluginService.afterActionPerformed(PluginService.java:178)
at com.kingdee.bos.appframework.client.servicebinding.ActionProxy.afterAction(ActionProxy.java:245)
at com.kingdee.bos.appframework.client.servicebinding.ActionProxy.actionPerformedInvoke(ActionProxy.java:183)
at com.kingdee.bos.appframework.client.servicebinding.ActionProxy.actionPerformed(ActionProxy.java:102)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
at java.awt.Component.processMouseEvent(Component.java:6288)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6053)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4651)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4481)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:643)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:602)
at java.awt.EventQueue$1.run(EventQueue.java:600)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
at java.awt.EventQueue$2.run(EventQueue.java:616)
at java.awt.EventQueue$2.run(EventQueue.java:614)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:613)
at com.kingdee.bos.invokecounter.RPCLogEventQueue.dispatchEvent(RPCLogEventQueue.java:176)
at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.kingdee.eas.client.recorder.UserInputEventQueue.myDispatchEvent(UserInputEventQueue.java:126)
at com.kingdee.eas.client.recorder.UserInputEventQueue.dispatchEvent(UserInputEventQueue.java:59)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: com.kingdee.bos.SQLDataException: null
Caused exception message is: ORA-00900: 无效 SQL 语句

at com.kingdee.bos.dao.query.server.SQLDataAccess.getRowSet(SQLDataAccess.java:112)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_ISQLDataAccess.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_ISQLDataAccess.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
Caused by: java.sql.SQLException: ORA-00900: 无效 SQL 语句

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:675)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:98)
at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:811)
at oracle.jdbc.driver.OracleStatement.describe(Unknown Source)
at oracle.jdbc.driver.OracleResultSetMetaData.(OracleResultSetMetaData.java:55)
at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:182)
at com.kingdee.bos.sql.shell.KDResultSet.getMetaData(KDResultSet.java:319)
at com.apusic.jdbc.adapter.ResultSetHandle.getMetaData(ResultSetHandle.java:323)
at com.kingdee.bos.dao.query.server.SQLDataAccess.createRowSet(SQLDataAccess.java:172)
at com.kingdee.bos.dao.query.server.SQLDataAccess.getRowSet(SQLDataAccess.java:81)
... 8 more
Caused by: com.kingdee.bos.SQLDataException
com.kingdee.bos.SQLDataException: null
Caused exception message is: ORA-00900: 无效 SQL 语句

at com.kingdee.bos.dao.query.server.SQLDataAccess.getRowSet(SQLDataAccess.java:112)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_ISQLDataAccess.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_ISQLDataAccess.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
Caused by: java.sql.SQLException: ORA-00900: 无效 SQL 语句

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:675)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:98)
at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:811)
at oracle.jdbc.driver.OracleStatement.describe(Unknown Source)
at oracle.jdbc.driver.OracleResultSetMetaData.(OracleResultSetMetaData.java:55)
at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:182)
at com.kingdee.bos.sql.shell.KDResultSet.getMetaData(KDResultSet.java:319)
at com.apusic.jdbc.adapter.ResultSetHandle.getMetaData(ResultSetHandle.java:323)
at com.kingdee.bos.dao.query.server.SQLDataAccess.createRowSet(SQLDataAccess.java:172)
at com.kingdee.bos.dao.query.server.SQLDataAccess.getRowSet(SQLDataAccess.java:81)
... 8 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-00900: 无效 SQL 语句

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:675)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:98)
at oracle.jdbc.driver.T4CPreparedStatement.doDescribe(T4CPreparedStatement.java:811)
at oracle.jdbc.driver.OracleStatement.describe(Unknown Source)
at oracle.jdbc.driver.OracleResultSetMetaData.(OracleResultSetMetaData.java:55)
at oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:182)
at com.kingdee.bos.sql.shell.KDResultSet.getMetaData(KDResultSet.java:319)
at com.apusic.jdbc.adapter.ResultSetHandle.getMetaData(ResultSetHandle.java:323)
at com.kingdee.bos.dao.query.server.SQLDataAccess.createRowSet(SQLDataAccess.java:172)
at com.kingdee.bos.dao.query.server.SQLDataAccess.getRowSet(SQLDataAccess.java:81)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_ISQLDataAccess.pi4(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_ISQLDataAccess.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)

推荐阅读

电子回单常见问题解答和常用sql整合

因为上传的文件有大小限制,单个文件不能超过4M,所以将源文件分成三个文件单独上传. :handshake 谢谢 ,{:5_152:} ,好资料 ,{:5_144 …

    文章

    535

sql语句行转列语句报错

谁帮我看看我写了一个sql语句，看看有什么错误，想实现行转列 select sum(case a.fperiod when 1 then b.famount e …

    文章

    1,585

金蝶云社区MySQL常见问题与解答

MySQL常见问题与解答

    文章

    891