java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

Oracle Community | user10233157 | 5 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Cant provision user using AD connector (9.1.1.7.2) in OIM (11.1.1.5.0)

    Oracle Community | 5 years ago | user10233157
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  2. 0

    Error executing a Oracle query when connection is fetched from Datasource

    Oracle Community | 4 years ago | 992632
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  3. 0

    Error Installing CS delivery - Table or view does not exist?

    Oracle Community | 5 years ago | 785434
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OIM 11.1.2.3 Create Organization recon event

    Oracle Community | 10 months ago | 1035694
    java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification
  6. 0

    Error executing a Oracle specific query when connection is fetched from Datasource

    Coderanch | 4 years ago | Rob Eddy
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLSyntaxErrorException

    ORA-00936: missing expression

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OracleStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
    8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1074)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
    10. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2224)
    11. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2168)
    12. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:333)
    12 frames
  3. weblogic.jdbc.wrapper
    Statement.execute
    1. weblogic.jdbc.wrapper.Statement.execute(Statement.java:466)
    1 frame
  4. oracle.iam.reconciliation
    ActionTask.execute
    1. oracle.iam.reconciliation.dao.ReconActionDao.executeOrgMatch(ReconActionDao.java:1351)
    2. oracle.iam.reconciliation.impl.OrganizationHandler.executeSingleEventMatch(OrganizationHandler.java:34)
    3. oracle.iam.reconciliation.impl.EntityTypeHandler.process(EntityTypeHandler.java:38)
    4. oracle.iam.reconciliation.impl.ActionEngine.processEvent(ActionEngine.java:209)
    5. oracle.iam.reconciliation.impl.ActionEngine.processEvent(ActionEngine.java:156)
    6. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:94)
    7. oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
    7 frames
  5. oracle.iam.platform
    MessageReceiver.onMessage
    1. oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:100)
    2. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:70)
    3. oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
    3 frames
  6. Java RT
    NativeMethodAccessorImpl.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    2 frames