UTL_DBWS - calling a web service from Oracle
Hope someone can help me. My problem is that I can’t seem to call any web services from Oracle (Oracle Database 10g Enterprise Edition Release 10.1.0.5.0.)
The web service I was originally working on can be invoked from a browser interface, but when invoked from Oracle I get the following err开发者_如何学Cor message:
Fel pσ rad 1:
ORA-29532: Java-anrop avslutades av ouppfσngat Java-undantag:
java.rmi.RemoteException: java.rmi.RemoteException: ; nested exception is:
dynamic invocation error: javax.xml.soap.SOAPException: Error parsing envelope
ORA-06512: vid “SYS.UTL_DBWS”, rad 404
ORA-06512: vid “SYS.UTL_DBWS”, rad 401
ORA-06512: vid “PRODPACK.HELLOWORLD”, rad 163
The first couple of lines are in Swedish, and are telling me politely that my code has caused an uncaught java exception.
I have tried to google this but have not been able to find anything that can help me.
I tried to call an example web service that I found in this article:
http://www.oracle-base.com/articles/10g/utl_dbws10g.php
But I get the same error.
Does anyone know what may be causing this?
I had a similar problem with utl_dbws and it turned out that we had a 'partial' install of java on our 10g instance. Our dba had to finish the installation and then everything worked.
However, even after that I switched to using UTL_HTTP (and another link)and found it easier (esp. since there seems to be more documentation around it and I had to go through a proxy)
精彩评论