Calling web service from oracle stored procedure

W

websphere

We are trying to call a simple java web service from a oracle stroed
proecedure.

It works fine with our any parameters and able to return a value back.
But when we try to pass arguments we are getting the following
exception.

Any ideas?
faultCode: Server.generalException
faultString: org.xml.sax.SAXException: WSWS3084E: Error:
SimpleDeserializer encountered a child element, which is NOT expected,
in something it was trying to deserialize.
faultActor: null
faultDetail:

org.xml.sax.SAXException: WSWS3084E: Error: SimpleDeserializer
encountered a child element, which is NOT expected, in something it was
trying to deserialize.
at
com.ibm.ws.webservices.engine.WebServicesFault.makeFault(WebServicesFault.java:150)
at
com.ibm.ws.webservices.engine.SOAPPart.getSOAPEnvelope(SOAPPart.java:868)
at
com.ibm.ws.webservices.engine.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:602)
at
com.ibm.ws.webservices.engine.Message.getSOAPEnvelope(Message.java:452)
at
com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCSOAPHandler.checkSOAPSemantics(JAXRPCSOAPHandler.java:218)
at
com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCSOAPHandler.invokeServerRequestHandler(JAXRPCSOAPHandler.java:188)
at
com.ibm.ws.webservices.engine.handlers.jaxrpc.JAXRPCHandler$1.invoke(JAXRPCHandler.java:214)
at
com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:195)
at
com.ibm.ws.webservices.engine.handlers.WrappedHandler.invoke(WrappedHandler.java:61)
at
com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:212)
at
com.ibm.ws.webservices.engine.PivotHandlerWrapper.invoke(PivotHandlerWrapper.java:212)
at
com.ibm.ws.webservices.engine.WebServicesEngine.invoke(WebServicesEngine.java:255)
at
com.ibm.ws.webservices.engine.transport.http.WebServicesServlet.doPost(WebServicesServlet.java:850)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at
com.ibm.ws.webservices.engine.transport.http.WebServicesServletBase.service(WebServicesServletBase.java:341)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182)
at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)
Caused by: org.xml.sax.SAXException: WSWS3084E: Error:
SimpleDeserializer encountered a child element, which is NOT expected,
in something it was trying to deserialize.
at
com.ibm.ws.webservices.engine.encoding.ser.SimpleDeserializer.onStartChild(SimpleDeserializer.java:165)
at
com.ibm.ws.webservices.engine.events.DEventProcessor.onSimpleChild(DEventProcessor.java:212)
at
com.ibm.ws.webservices.engine.events.P2DConverter.flush(P2DConverter.java:728)
at
com.ibm.ws.webservices.engine.events.P2DConverter.endElement(P2DConverter.java:395)
at sax.SAX2DocumentEntityParserBase.endElementAction(Unknown Source)
at util.DocumentEntityParserBase.endElementEvent(Unknown Source)
at
com.ibm.xml.b2b.scan.latin.LatinWFCDocumentScanner.scanEndElement(Unknown
Source)
at
com.ibm.xml.b2b.scan.latin.LatinWFCDocumentScanner.scanContent(Unknown
Source)
at
com.ibm.xml.b2b.scan.latin.LatinWFCDocumentScanner.scanDocument(Unknown
Source)
at sax.latin.LatinWFCSAX2DocumentEntityParser.scanDocument(Unknown
Source)
at util.DocumentEntityParserBase.parse(Unknown Source)
at sax.SAX2DocumentEntityParserBase.parseEntity(Unknown Source)
at sax.SAX2DocumentEntityParserBase.parse(Unknown Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at
com.ibm.ws.webservices.engine.encoding.DeserializationContextImpl.parse(DeserializationContextImpl.java:251)
at
com.ibm.ws.webservices.engine.SOAPPart.getSOAPEnvelope(SOAPPart.java:864)
... 33 more
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,012
Latest member
RoxanneDzm

Latest Threads

Top