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

Oracle Community | 819936 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Send Email Notification failing

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

    Target REconciliation

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

    Error request using dataset which contains child form

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

  1. bpbhat77 1 times, last 9 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:1034)
    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:1187)
    11. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1378)
    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
    tcUserOperations_voj9p2_EOImpl.provisionObject
    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.util.tcEmailNotificationUtil.getFromAddress(Unknown Source)
    9. com.thortech.xl.dataobj.util.tcEmailNotificationUtil.constructEmail(Unknown Source)
    10. com.thortech.xl.dataobj.util.tcEmailNotificationUtil.constructEmail(Unknown Source)
    11. com.thortech.xl.dataobj.tcScheduleItem.checkForEmailNotification(Unknown Source)
    12. com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(Unknown Source)
    13. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    14. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    15. com.thortech.xl.dataobj.tcORC.insertNonConditionalMilestones(Unknown Source)
    16. com.thortech.xl.dataobj.tcORC.completeSystemValidationMilestone(Unknown Source)
    17. com.thortech.xl.dataobj.tcORC.postInsertSysVal(Unknown Source)
    18. com.thortech.xl.dataobj.tcORC.eventPostInsert(Unknown Source)
    19. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    20. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    21. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    22. com.thortech.xl.dataobj.util.tcOrderPackages.createProcessORC(Unknown Source)
    23. com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(Unknown Source)
    24. com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(Unknown Source)
    25. com.thortech.xl.dataobj.tcOIU.provision(Unknown Source)
    26. com.thortech.xl.dataobj.tcOIU.eventPostInsert(Unknown Source)
    27. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    28. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    29. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
    30. com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(Unknown Source)
    31. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
    32. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
    33. com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.provisionObject(Unknown Source)
    34. com.thortech.xl.ejb.beans.tcUserOperationsSession.provisionObject(Unknown Source)
    35. com.thortech.xl.ejb.beansimpl.tcUserOperationsBean.provisionObject(Unknown Source)
    36. com.thortech.xl.ejb.beans.tcUserOperationsSession.provisionObject(Unknown Source)
    37. com.thortech.xl.ejb.beans.tcUserOperations_voj9p2_EOImpl.provisionObject(tcUserOperations_voj9p2_EOImpl.java:3413)
    37 frames
  5. Thor.API.Operations
    tcUserOperationsClient.provisionObject
    1. Thor.API.Operations.tcUserOperationsClient.provisionObject(Unknown Source)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor447.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  7. Thor.API.Base
    SecurityInvocationHandler$1.run
    1. Thor.API.Base.SecurityInvocationHandler$1.run(Unknown Source)
    1 frame
  8. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  9. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  10. weblogic.security
    Security.runAs
    1. weblogic.security.Security.runAs(Security.java:41)
    1 frame
  11. Thor.API.Security
    weblogicLoginSession.runAs
    1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source)
    1 frame
  12. Thor.API.Base
    SecurityInvocationHandler.invoke
    1. Thor.API.Base.SecurityInvocationHandler.invoke(Unknown Source)
    1 frame
  13. Unknown
    $Proxy65.provisionObject
    1. $Proxy65.provisionObject(Unknown Source)
    1 frame
  14. com.thortech.xl
    DirectProvisionUserAction.goNext
    1. com.thortech.xl.webclient.actions.DirectProvisionUserAction.handleVerifyResource(Unknown Source)
    2. com.thortech.xl.webclient.actions.DirectProvisionUserAction.goNext(Unknown Source)
    2 frames
  15. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor299.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  16. struts
    DispatchAction.dispatchMethod
    1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
    1 frame
  17. com.thortech.xl
    tcAction.execute
    1. com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(Unknown Source)
    2. com.thortech.xl.webclient.actions.tcActionBase.execute(Unknown Source)
    3. com.thortech.xl.webclient.actions.tcAction.execute(Unknown Source)
    3 frames
  18. struts
    ActionServlet.doPost
    1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    3. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    4. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    4 frames
  19. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    2 frames
  20. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
    2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
    3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  21. com.thortech.xl
    CSRFFilter.doFilter
    1. com.thortech.xl.webclient.security.CSRFFilter.doFilter(Unknown Source)
    1 frame
  22. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  23. com.thortech.xl
    SecurityFilter.doFilter
    1. com.thortech.xl.webclient.security.SecurityFilter.doFilter(Unknown Source)
    1 frame
  24. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3588)
    2 frames
  25. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  26. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  27. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2200)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2106)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1428)
    3 frames
  28. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    2 frames