java.lang.RuntimeException: com.sun.xml.ws.fault.ServerSOAPFaultException: Client received SOAP Fault from server: JBO-27122: SQL error during statement preparation. Statement: SELECT FROM DEPT Dept WHERE (Dept.DEPTNO = :fbkKy__0): ORA-00936: missing expression Please see the server log to find more detail regarding exact cause of the failure.

Oracle Community | 2958994 | 1 year 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

    Adf business components as services

    Oracle Community | 1 year ago | 2958994
    java.lang.RuntimeException: com.sun.xml.ws.fault.ServerSOAPFaultException: Client received SOAP Fault from server: JBO-27122: SQL error during statement preparation. Statement: SELECT FROM DEPT Dept WHERE (Dept.DEPTNO = :fbkKy__0): ORA-00936: missing expression Please see the server log to find more detail regarding exact cause of the failure.

    1 unregistered visitors

    Root Cause Analysis

    1. com.sun.xml.ws.fault.ServerSOAPFaultException

      Client received SOAP Fault from server: JBO-27122: SQL error during statement preparation. Statement: SELECT FROM DEPT Dept WHERE (Dept.DEPTNO = :fbkKy__0): ORA-00936: missing expression Please see the server log to find more detail regarding exact cause of the failure.

      at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException()
    2. JAX-WS RI Runtime Bundle
      DispatchImpl.invoke
      1. com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:193)
      2. com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:131)
      3. com.sun.xml.ws.client.dispatch.DispatchImpl.doInvoke(DispatchImpl.java:274)
      4. com.sun.xml.ws.client.dispatch.DispatchImpl.invoke(DispatchImpl.java:304)
      4 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    4. weblogic.wsee.jaxws
      ClientInstanceInvocationHandler.invoke
      1. weblogic.wsee.jaxws.spi.ClientInstanceInvocationHandler.invoke(ClientInstanceInvocationHandler.java:87)
      1 frame
    5. com.sun.proxy
      $Proxy196.invoke
      1. com.sun.proxy.$Proxy196.invoke(Unknown Source)
      1 frame
    6. com.oracle.webservices
      WebserviceResource.invokeWebServiceByFormURLEncoded
      1. com.oracle.webservices.testclient.core.ws.cdf.Engine.invoke(Engine.java:201)
      2. com.oracle.webservices.testclient.core.ws.cdf.SOAPBindingEngine.call(SOAPBindingEngine.java:60)
      3. com.oracle.webservices.testclient.wstest.InvocationDelegate.invoke(InvocationDelegate.java:46)
      4. com.oracle.webservices.testclient.wstest.WsTestCaller.invokeOpertion(WsTestCaller.java:95)
      5. com.oracle.webservices.testclient.ws.action.WsInvokeAction.execute(WsInvokeAction.java:67)
      6. com.oracle.webservices.testclient.ws.action.AbstractAction.process(AbstractAction.java:36)
      7. com.oracle.webservices.testclient.ws.res.WebserviceResource.invokeWebService(WebserviceResource.java:206)
      8. com.oracle.webservices.testclient.ws.res.WebserviceResource.invokeWebServiceByFormURLEncoded(WebserviceResource.java:179)
      8 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    8. Jersey
      WebApplicationImpl.handleRequest
      1. com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
      2. com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
      3. com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
      4. com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
      5. com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
      6. com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
      7. com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
      8. com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
      9. com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
      10. com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
      11. com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
      12. com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
      12 frames
    9. Jersey
      ServletContainer.service
      1. com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
      2. com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540)
      3. com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715)
      3 frames
    10. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
      1 frame
    11. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
      2. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
      3. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
      4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
      5. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
      6. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      6 frames
    12. com.oracle.webservices
      LocaleFilter.doFilter
      1. com.oracle.webservices.testclient.web.LocaleFilter.doFilter(LocaleFilter.java:25)
      1 frame
    13. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    14. com.oracle.webservices
      TestPageAccessFilter.doFilter
      1. com.oracle.webservices.testclient.wlsweb.TestPageAccessFilter.doFilter(TestPageAccessFilter.java:43)
      1 frame
    15. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)
      3 frames
    16. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    17. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    18. weblogic.servlet.provider
      WlsSubjectHandle.run
      1. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
      1 frame
    19. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)
      2. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)
      3. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
      4. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)
      4 frames
    20. weblogic.servlet.provider
      ContainerSupportProviderImpl$WlsRequestExecutor.run
      1. weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
      1 frame
    21. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
      2 frames