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

Oracle Community | TimBenga | 4 years ago
  1. 0

    Error request using dataset which contains child form

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

    Send Email Notification failing

    Oracle Community | 6 years ago | 819936
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  3. 0

    Target REconciliation

    Oracle Community | 6 years ago | Srivatsa.kashyap
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OIM 10g : SQL Script to Delete or Cancel process instance tasks for user resources

    Oracle Community | 3 years ago | mdadik13
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  6. 0

    OIM 9.1 : SQL Error while executing SQL DELETE Statement inside Java Adapter

    Oracle Community | 3 years ago | mdadik13
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

  1. bpbhat77 1 times, last 6 months ago
8 unregistered visitors
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.executeQuery
    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.executeForDescribe(T4CStatement.java:919)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1668)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:432)
    12 frames
  3. weblogic.jdbc.wrapper
    Statement.executeQuery
    1. weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:487)
    1 frame
  4. com.thortech.xl
    tcProvisioningOperationsBean.retryTasks
    1. com.thortech.xl.util.JDBCUtils.executeQuery(JDBCUtils.java:159)
    2. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:728)
    3. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:271)
    4. com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:935)
    5. com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1523)
    6. com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:903)
    7. com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1490)
    8. com.thortech.xl.adapterfactory.events.tcAdpEvent.getChildTableFieldValue(tcAdpEvent.java:2175)
    9. com.thortech.xl.adapterfactory.events.tcAdpEvent.getRunTimeValue(tcAdpEvent.java:808)
    10. com.thortech.xl.adapterfactory.events.tcAdpEvent.getRunTimeValue(tcAdpEvent.java:682)
    11. com.thortech.xl.adapterGlue.ScheduleItemEvents.adpADDUSERTORESOURCE.implementation(adpADDUSERTORESOURCE.java:49)
    12. com.thortech.xl.client.events.tcBaseEvent.run(tcBaseEvent.java:196)
    13. com.thortech.xl.dataobj.tcDataObj.runEvent(tcDataObj.java:2492)
    14. com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(tcScheduleItem.java:2917)
    15. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(tcScheduleItem.java:547)
    16. com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
    17. com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
    18. com.thortech.xl.ejb.beansimpl.tcProvisioningOperationsBean.retryTasks(tcProvisioningOperationsBean.java:4042)
    18 frames
  5. Thor.API.Operations
    tcProvisioningOperationsIntfEJB.retryTasksx
    1. Thor.API.Operations.tcProvisioningOperationsIntfEJB.retryTasksx(Unknown Source)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  7. com.bea.core
    AopUtils.invokeJoinpointUsingReflection
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    1 frame