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

Oracle Community | Srivatsa.kashyap | 6 years ago
  1. 0

    Target REconciliation

    Oracle Community | 6 years ago | Srivatsa.kashyap
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  2. 0

    Recon staus at Event Received

    Oracle Community | 6 years ago | 790345
    java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name
  3. 0

    Send Email Notification failing

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

    Automated exception search integrated into your IDE

  5. 0

    Error request using dataset which contains child form

    Oracle Community | 4 years ago | TimBenga
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  6. 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

  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.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OracleStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    8. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
    9. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1188)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1379)
    12. oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:387)
    12 frames
  3. weblogic.jdbc.wrapper
    Statement.executeQuery
    1. weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:479)
    1 frame
  4. com.thortech.xl
    tcRCE_4tknfu_EOImpl_WLSkel.invoke
    1. com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)
    2. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
    3. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
    4. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
    5. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
    6. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
    7. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
    8. com.thortech.xl.dataobj.tcORC.setOrcTosInstanceKeyFromMap(Unknown Source)
    9. com.thortech.xl.dataobj.tcORC.eventPreInsert(Unknown Source)
    10. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    11. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    12. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    13. com.thortech.xl.dataobj.util.tcOrderPackages.createProcessORC(Unknown Source)
    14. com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(Unknown Source)
    15. com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(Unknown Source)
    16. com.thortech.xl.dataobj.tcOIU.provision(Unknown Source)
    17. com.thortech.xl.dataobj.tcOIU.eventPostInsert(Unknown Source)
    18. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    19. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    20. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    21. com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(Unknown Source)
    22. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    23. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    24. com.thortech.xl.dataobj.tcRCE.provisionObject(Unknown Source)
    25. com.thortech.xl.dataobj.tcRCE.linkToUser(Unknown Source)
    26. com.thortech.xl.ejb.databeansimpl.tcRCEBean.linkToUser(Unknown Source)
    27. com.thortech.xl.ejb.beans.tcRCE_4tknfu_EOImpl.linkToUser(tcRCE_4tknfu_EOImpl.java:4439)
    28. com.thortech.xl.ejb.beans.tcRCE_4tknfu_EOImpl_WLSkel.invoke(Unknown Source)
    28 frames
  5. weblogic.rmi.internal
    BasicServerRef$1.run
    1. weblogic.rmi.internal.activation.ActivatableServerRef.invoke(ActivatableServerRef.java:85)
    2. weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
    2 frames
  6. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
    1 frame
  7. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
    1 frame
  8. weblogic.rmi.internal
    WLSExecuteRequest.run
    1. weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
    2. weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
    2 frames
  9. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    2 frames