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

Oracle Community | Federator | 10 months 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. 1

    Catalog search operations give ADF error

    Oracle Community | 10 months ago | Federator
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  2. 0

    ORABPEL-9708 Error while querying workflow task WFTask. Caused by:ORA-00936

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

    Automated exception search integrated into your IDE

  4. 0

    Getting conflict with DD-MON-RR format

    Stack Overflow | 7 months ago | smith
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  5. 0

    Admin server running into issues in SOA.

    Oracle Community | 4 years ago | 1007055
    java.sql.SQLSyntaxErrorException: ORA-00904: "TENANT_ID": 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
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    1 frame
  4. oracle.iam.catalog
    CatalogServiceImpl.findCatalog
    1. oracle.iam.catalog.repository.DBRepository.executeFinderOpenCatalog(DBRepository.java:2661)
    2. oracle.iam.catalog.repository.DBRepository.findCatalog(DBRepository.java:2496)
    3. oracle.iam.catalog.impl.CatalogServiceImpl.findCatalog(CatalogServiceImpl.java:260)
    3 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor4919.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  6. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  7. oracle.iam.platform
    DMSMethodInterceptor.invoke
    1. oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25)
    1 frame
  8. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  9. com.sun.proxy
    $Proxy556.findCatalog
    1. com.sun.proxy.$Proxy556.findCatalog(Unknown Source)
    1 frame
  10. oracle.iam.catalog
    CatalogServiceEJB.findCatalogx
    1. oracle.iam.catalog.api.CatalogServiceEJB.findCatalogx(Unknown Source)
    1 frame
  11. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor4918.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  12. com.bea.core
    ReflectiveMethodInvocation.proceed
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    6 frames
  13. com.oracle.pitchfork
    MethodInvocationVisitorImpl.visit
    1. com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
    1 frame
  14. weblogic.ejb.container
    EnvironmentInterceptorCallbackImpl.callback
    1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
    1 frame
  15. com.oracle.pitchfork
    EnvironmentInterceptor.invoke
    1. com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)
    1 frame
  16. com.bea.core
    JdkDynamicAopProxy.invoke
    1. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    7. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    7 frames
  17. com.sun.proxy
    $Proxy555.findCatalogx
    1. com.sun.proxy.$Proxy555.findCatalogx(Unknown Source)
    1 frame
  18. oracle.iam.catalog
    CatalogService_vxl1s5_CatalogServiceRemoteImpl.__WL_invoke
    1. oracle.iam.catalog.api.CatalogService_vxl1s5_CatalogServiceRemoteImpl.__WL_invoke(Unknown Source)
    1 frame
  19. weblogic.ejb.container
    SessionRemoteMethodInvoker.invoke
    1. weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
    1 frame
  20. oracle.iam.catalog
    CatalogService_vxl1s5_CatalogServiceRemoteImpl_WLSkel.invoke
    1. oracle.iam.catalog.api.CatalogService_vxl1s5_CatalogServiceRemoteImpl.findCatalogx(Unknown Source)
    2. oracle.iam.catalog.api.CatalogService_vxl1s5_CatalogServiceRemoteImpl_WLSkel.invoke(Unknown Source)
    2 frames
  21. weblogic.rmi.internal
    ServerRequest.sendReceive
    1. weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
    1 frame
  22. weblogic.rmi.cluster
    ClusterableRemoteRef.invoke
    1. weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:345)
    2. weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
    2 frames
  23. oracle.iam.catalog
    CatalogService_vxl1s5_CatalogServiceRemoteImpl_1036_WLStub.findCatalogx
    1. oracle.iam.catalog.api.CatalogService_vxl1s5_CatalogServiceRemoteImpl_1036_WLStub.findCatalogx(Unknown Source)
    1 frame
  24. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor4917.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  25. weblogic.ejb.container
    RemoteBusinessIntfProxy.invoke
    1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
    1 frame
  26. com.sun.proxy
    $Proxy554.findCatalogx
    1. com.sun.proxy.$Proxy554.findCatalogx(Unknown Source)
    1 frame
  27. oracle.iam.catalog
    CatalogServiceDelegate.findCatalog
    1. oracle.iam.catalog.api.CatalogServiceDelegate.findCatalog(Unknown Source)
    1 frame
  28. oracle.iam.ui
    OIMProgrammaticVO.retrieveByKey
    1. oracle.iam.ui.common.model.catalog.CartItemsDataProvider.search(CartItemsDataProvider.java:142)
    2. oracle.iam.ui.platform.model.common.OIMProgrammaticVO.retrieveByKey(OIMProgrammaticVO.java:902)
    2 frames
  29. oracle.jbo.server
    ViewObjectImpl.findByKey
    1. oracle.jbo.server.ViewObjectImpl.retrieveByKey(ViewObjectImpl.java:17226)
    2. oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5593)
    3. oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5351)
    4. oracle.jbo.server.ViewRowSetImpl.findByKey(ViewRowSetImpl.java:5345)
    5. oracle.jbo.server.ViewObjectImpl.findByKey(ViewObjectImpl.java:11735)
    5 frames
  30. oracle.jbo.uicli
    JUCtrlHierBinding.bringNodeToRangeKeyPath
    1. oracle.jbo.uicli.binding.JUCtrlHierBinding.bringNodeToRangeKeyPath(JUCtrlHierBinding.java:794)
    1 frame
  31. oracle.adfinternal.view
    FacesCtrlHierBinding$FacesModel.setRowKey
    1. oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding.bringNodeToRangeKeyPath(FacesCtrlHierBinding.java:107)
    2. oracle.adfinternal.view.faces.model.binding.RowDataManager.setRowKey(RowDataManager.java:133)
    3. oracle.adfinternal.view.faces.model.binding.FacesCtrlHierBinding$FacesModel.setRowKey(FacesCtrlHierBinding.java:659)
    3 frames
  32. Apache MyFaces Trinidad API
    UIXTable.broadcast
    1. org.apache.myfaces.trinidad.component.UIXCollection.setRowKey(UIXCollection.java:442)
    2. org.apache.myfaces.trinidad.component.UIXCollection.broadcast(UIXCollection.java:148)
    3. org.apache.myfaces.trinidad.component.UIXTable.broadcast(UIXTable.java:279)
    3 frames
  33. oracle.adf.view
    UIXInclude.broadcast
    1. oracle.adf.view.rich.component.UIXTable.broadcast(UIXTable.java:145)
    2. oracle.adf.view.rich.component.rich.data.RichTable.broadcast(RichTable.java:427)
    3. oracle.adf.view.rich.component.fragment.UIXRegion.broadcast(UIXRegion.java:181)
    4. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:104)
    5. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:93)
    6. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:371)
    7. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:97)
    8. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:98)
    8 frames
  34. oracle.adfinternal.view
    LifecycleImpl.execute
    1. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.broadcastEvents(LifecycleImpl.java:1086)
    2. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:434)
    3. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:207)
    3 frames
  35. JavaEE 7
    FacesServlet.service
    1. javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
    1 frame
  36. 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:301)
    4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    5 frames
  37. oracle.help.web
    OHWFilter.doFilter
    1. oracle.help.web.rich.OHWFilter.doFilter(Unknown Source)
    1 frame
  38. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  39. oracle.adf.model
    ADFBindingFilter.doFilter
    1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:205)
    1 frame
  40. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  41. oracle.adf.view
    WebCenterComposerFilter.doFilter
    1. oracle.adf.view.page.editor.webapp.WebCenterComposerFilter.doFilter(WebCenterComposerFilter.java:117)
    1 frame
  42. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  43. oracle.adfinternal.view
    RegistrationFilter.doFilter
    1. oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:128)
    1 frame
  44. org.apache.myfaces
    TrinidadFilterImpl$FilterListChain.doFilter
    1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
    1 frame
  45. oracle.adfinternal.view
    AdsFilter.doFilter
    1. oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
    1 frame
  46. org.apache.myfaces
    TrinidadFilterImpl.doFilter
    1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:446)
    2. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:271)
    3. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:177)
    3 frames
  47. Apache MyFaces Trinidad API
    TrinidadFilter.doFilter
    1. org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
    1 frame
  48. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  49. oracle.iam.ui
    IdentityContextFilter.doFilter
    1. oracle.iam.ui.platform.servletfilter.IdentityContextFilter.doFilter(IdentityContextFilter.java:50)
    1 frame
  50. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  51. oracle.iam.platform
    PwdMgmtNavigationFilter.doFilter
    1. oracle.iam.platform.servletfilter.PwdMgmtNavigationFilter.doFilter(PwdMgmtNavigationFilter.java:164)
    1 frame
  52. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  53. oracle.bpel.services
    WorkflowFilter.doFilter
    1. oracle.bpel.services.workflow.client.worklist.util.WorkflowFilter.doFilter(WorkflowFilter.java:175)
    1 frame
  54. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  55. oracle.bpel.services
    DisableUrlSessionFilter.doFilter
    1. oracle.bpel.services.workflow.client.worklist.util.DisableUrlSessionFilter.doFilter(DisableUrlSessionFilter.java:70)
    1 frame
  56. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  57. oracle.adf.library
    LibraryFilter.doFilter
    1. oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:180)
    1 frame
  58. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  59. oracle.security.jps
    JpsFilter.doFilter
    1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
    2. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
    3. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
    4. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
    5. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
    6. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
    6 frames
  60. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  61. oracle.security.wls
    SSOSessionSynchronizationFilter.doFilter
    1. oracle.security.wls.filter.SSOSessionSynchronizationFilter.doFilter(SSOSessionSynchronizationFilter.java:418)
    1 frame
  62. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  63. oracle.security.am
    OAMValidationSystemFilter.doFilter
    1. oracle.security.am.agent.wls.filters.OAMServletAuthenticationFilter.doFilter(OAMServletAuthenticationFilter.java:265)
    2. oracle.security.am.agent.wls.filters.OAMValidationSystemFilter.doFilter(OAMValidationSystemFilter.java:133)
    2 frames
  64. oracle.security.wls
    OAMAgentWrapperFilter.doFilter
    1. oracle.security.wls.oamagent.OAMAgentWrapperFilter.doFilter(OAMAgentWrapperFilter.java:120)
    1 frame
  65. Atmosphere weblogic
    FilterChainImpl.doFilter
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    1 frame
  66. oracle.dms.servlet
    DMSServletFilter.doFilter
    1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
    1 frame
  67. Atmosphere weblogic
    WebAppServletContext$ServletInvocationAction.run
    1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
    3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    5 frames
  68. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  69. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
    1 frame
  70. Atmosphere weblogic
    ServletRequestImpl.run
    1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
    2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1485)
    3 frames
  71. weblogic.work
    ExecuteThread.run
    1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    2 frames