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

Oracle Community | 819936 | 6 years ago
  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 | 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 5 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