How to Properly Install the Java Based Web Service Client (UTL_DBWS) in 11gR2 or 12cR1 (Doc ID 2537545.1)

Last updated on JUNE 30, 2023

Applies to:

Goal

As there appear to be multiple notes on this subject and all are lacking necessary information or providing misinformation such as installing in SYS schema, the goal of this note is to provide clear steps to install the Java Based Web Service Client (UTL_DBWS) API in order to make SOAP and REST requests from PL/SQL.  Although this functionality is reaching end-of-life, this API can be used to work around issues with the UTL_HTTP API which is integrated into the Oracle database server code. This package is based on JPublisher and is therefore not supported in 12cR2 and up.  Starting in 12cR2, this functionality is replaced with the Oracle JVM Web Callout Utility (OJVMWCU).   For SOAP Web Services, the OJVMWCU uses the JAX-WS library and generates Java client stubs based on the WSDL file of the specific web service. For REST services, it uses the Third Party Tool wadl2java.  If you found this note expecting to perform call outs to web services in a 12.2 or newer release, then refer to the documentation on the OJVMWCU here.

Also, the steps below were tested on 11.2.0.4 and 12.1.0.2 standalone instances on a Linux X86-64 platform.  Although it was not tested on Windows, the steps should be the same since everything (SQL and PL/SQL as well as the Java code) is platform independent. Also, although this functionality can be installed in a 12.1 "Container Database" environment, it should be installed in the PDB and not at the container level.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.