搜索
您的当前位置:首页正文

SQLSyntaxErrorException: ORA-00936: missing expression

来源:尚车旅游网

oracle中执行sql语句:
报下列错误:

 com.inspur.meta.db2db.dao.StageExportDao:(213) java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
		
			at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
			at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
			at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
			at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
			at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
			at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
			at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
			at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
			at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
			at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
			at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
			at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
			at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
			at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)

原因是:缺失表达式,证明写的sql语句有问题,好好检查一下
sql语句,多标点,少引号之类的问题。

因篇幅问题不能全部显示,请点此查看更多更全内容

Top