UTL_DBWS-从Oracle调用Web服务 [英] UTL_DBWS - calling a web service from Oracle

问题描述

希望有人可以帮助我.我的问题是我似乎无法从Oracle (Oracle Database 10g Enterprise Edition Release 10.1.0.5.0.)

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.)

我最初使用的Web服务可以从浏览器界面中调用，但是从Oracle调用时，我会收到以下错误消息:

The web service I was originally working on can be invoked from a browser interface, but when invoked from Oracle I get the following error 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

前几行是瑞典语，并礼貌地告诉我，我的代码已引起未捕获的Java异常.

The first couple of lines are in Swedish, and are telling me politely that my code has caused an uncaught java exception.

我曾尝试用Google搜索此内容，但找不到任何可以帮助我的内容.

I have tried to google this but have not been able to find anything that can help me.

我试图调用本文中找到的示例Web服务:

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?

推荐答案

我在utl_dbws上也遇到了类似的问题，结果发现我们在10g实例上安装了Java的部分"安装.我们的dba必须完成安装，然后一切正常.

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)

这篇关于UTL_DBWS-从Oracle调用Web服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！