Problems Installing Utl_dbws On Oracle RDBMS 11.2.0.3 EE (Doc ID 1568958.1)

Last updated on FEBRUARY 13, 2024

Applies to:

Symptoms

UTL_DBWS was successfully installed in Oracle database 11.2.0.3.
The celciusToFahrenheit webservice was also tested successfully using:
Using UTL_DBWS to Make a Database 11g Callout to a Document Style Web Service (Doc ID 841183.1)

But when the add_numbers function is called, it works fine for the first time.
But second and subsequent invocations fail with the exception:

DECLARE
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
javax.xml.rpc.soap.SOAPFaultException: error in msg parsing:
xml was empty, didn't parse!
ORA-06512: at "<USER>.UTL_DBWS", line 404
ORA-06512: at "<USER>.UTL_DBWS", line 401
ORA-06512: at line 44
ORA-06512: at line 54
ORA-06512: at line 72


Observations
1.  The same function works fine when UTL_DBWS is installed / used in Oracle database 10.2.0.3.0.
2.  There is no http_proxy used and it was observed that the problem disappears when http_proxy is used.

Changes

Cause

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