使用PL/SQL使用Web服务:UTL_DBWS或APEX_WEB_SERVICE? [英] Consume web service with PL/SQL: UTL_DBWS or APEX_WEB_SERVICE?

问题描述

我正在考虑使用PL/SQL中的Web服务.似乎至少有两种可能，软件包UTL_DBWS和软件包APEX_WEB_SERVICE(以及UTL_HTTP，但我们不要去那里了).

I'm looking into consuming a web service from PL/SQL. There seem to be at least two possibilities, the package UTL_DBWS and the package APEX_WEB_SERVICE (and UTL_HTTP, but let's not go there).

今天安装在Apex上且运行在11.2或12.2上的是哪个?为什么呢?

Which is today the prefered one, running on 11.2 or 12.2, with Apex installed? And why?

推荐答案

UTL_DBWS是JPublisher程序(Java存储过程)上的PL/SQL包装.它仅支持SOAP.

UTL_DBWS is a PL/SQL wrapper over the JPublisher programs (Java Stored Procedures). It only supports SOAP.

APEX_WEB_SERVICE支持SOAP和REST. RESTful Web服务构成了现代Web的主流架构.因此，如果您安装了Apex，为什么不使用APEX_WEB_SERVICE?

APEX_WEB_SERVICE supports SOAP and REST. RESTful web services forms the prevailing architecture for the modern web. So if you have Apex installed why wouldn't you use APEX_WEB_SERVICE?

"UTL_HTTP，但我们不要去那里"

"UTL_HTTP, but let's not go there"

对于临时搜索者，UTL_HTTP是这些软件包中最古老的软件包，因此提供了较低级别的API.对于大多数用例，较高级别的软件包是更好的选择.

For the casual Seeker, UTL_HTTP is the oldest of these packages and consequently provides a lower level API. For most use cases the higher level packages are the better choice.

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