ORA-00936-Missing-Expression

About ORA-00936 online to find the way to deal:

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:

An exception is thrown during application Compilation:
Java. SQL. sqlexception: ORA-00936: Missing expression

After carefully checking the exception content, I found that my DBA had a problem. If I checked the database connection and SQL statements and found that there were no problems, I checked the Weblogic console, the problem is found that the path in the JDBC connection pools is incorrect. After the modification is correct, it runs and the exception disappears.