关于ORA-00936网上找到的处理方法的:
1:ORA-00936, ORA-936 is a generic error indicating a missing expression in the SQL statement that you have just executed. Most probably this error is indicating that you have either missed a , [ comma ] or the from clause or where clause or some other part of the SQL that has just been parsed.
ORA-00936:missing expression
ORA-00936 Cause:A required part of a clause or expression has been omitted. For example, a SELECT statement may have been entered without a list of columns or expressions or with an incomplete expression. This message is also issued in cases where a reserved word is misused, as in SELECT TABLE.
ORA-00936 Action:Check the statement syntax and specify the missing component.
2:在编译应用的时候,抛出异常:
java.sql.SQLException:ORA-00936:missing expression
认真检查异常内容后发现我的dba有问题,如是检查数据库连接和sql语句,发现这些都没有问题,于是检查Weblogic console ,发现问题出在jdbc
connection pools 中的路径不正确,修改正确后运行,异常消失。
--转自