Consuming the webservice in PLSQL

[Former Member]

Dear Experts,

I have created a webservice using NWDS and deployed it in EP Java Stack and i was able to test this webservice from WSNavigator.

Now when i am trying to consume the same webservice from PLSQL. I am getting the below exception

ORA-29532: Java call terminated by uncaught Java exception: service: {urnLAMWSWsd/OLAMConfig/document}OLAMWS does not contain port: {urnLAMWSWsd/OLAMConfig/document}OLAMConfigPort_Document

please advice what to do

Thanks and Regards

Hari Krishna

[Former Member · Accepted solution]

Hi,

I also think that there is something wrong with the call from PLSQL but try testing the webservice using SoapUI or XMLSpy or any other SOAP client. If it works fine that way then you have conclusive proof that you need to re-check your request call in PLSQL.

Regards, Trevor

[Former Member]

I don't know how to call a WS from PLSQL but it seems that something is wrong in your call.

Give a try to tcpmon ([http://ws.apache.org/commons/tcpmon/|http://ws.apache.org/commons/tcpmon/]) and you will see what is send and received in every call.