Problems Installing Utl_dbws On Oracle RDBMS 11.2.0.3 EE

(Doc ID 1568958.1)

Last updated on MARCH 20, 2017

Applies to:

Web Services - Version 10.1.3.1.0 to 10.1.3.1.0 [Release Oracle10g]
Information in this document applies to any platform.

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 "PANDA.UTL_DBWS", line 404
ORA-06512: at "PANDA.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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms