使用Oracle PL/SQL中的Web服务 [英] Consuming web services from Oracle PL/SQL

问题描述

这些天，我们的应用程序正在与许多Web服务接口.我们有我们自己的软件包，几年前有人使用UTL_HTTP编写了它，并且通常可以使用，但是需要对SOAP信封进行一些硬编码才能与某些系统一起使用.我想使其更加通用，但是缺乏经验，无法知道我将要处理多少种情况.变化之处在于需要声明的名称空间以及元素的格式.我们既要处理带有几个参数的简单调用，又要处理以编码字符串形式传递大量数据的那些调用.

Our application is interfacing with a lot of web services these days. We have our own package that someone wrote a few years back using UTL_HTTP and it generally works, but needs some hard-coding of the SOAP envelope to work with certain systems. I would like to make it more generic, but lack experience to know how many scenarios I would have to deal with. The variations are in what namespaces need to be declared and the format of the elements. We have to handle both simple calls with a few parameters and those that pass a large amount of data in an encoded string.

我知道10g具有UTL_DBWS，但在线上没有大量用例.它足够稳定和灵活，足以用于一般用途吗? 文档

I know that 10g has UTL_DBWS, but there are not a huge number of use-cases on-line. Is it stable and flexible enough for general use? Documentation

推荐答案

我使用了UTL_HTTP，它很简单而且有效.如果您面对自己的程序包所面临的挑战，则可以在网上围绕UTL_HTTP的众多包装程序包中找到一种解决方案(Google从pl/sql消费Web服务"，例如 http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php )

I have used UTL_HTTP which is simple and works. If you face a challenge with your own package, you can probably find a solution in one of the many wrapper packages around UTL_HTTP on the net (Google "consuming web services from pl/sql", leading you to e.g. http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php)

没有人使用UTL_DBWS的原因是它在默认安装的数据库中不起作用.您需要将大量Java类加载到数据库中，但是标准指令似乎有缺陷-该过程会左右产生Java错误，最终会失败.似乎很少有人愿意花时间来跟踪软件包的依赖关系，以使此方法有效.

The reason nobody is using UTL_DBWS is that it is not functional in a default installed database. You need to load a ton of Java classes into the database, but the standard instructions seem to be defective - the process spews Java errors right and left and ultimately fails. It seems very few people have been willing to take the time to track down the package dependencies in order to make this approach work.

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