UTL_DBWS Returns "javax.xml.soap.SOAPException: Bad response: 403 Forbidden" (Doc ID 1612378.1)

Last updated on FEBRUARY 13, 2024

Applies to:

Symptoms

After installing UTL_DBWS on an Oracle Database (any version could exhibit this behavior) and attempting to connect to an external web service, the following exception is reported:

For example, using the web service callout mentioned in Note 412666.1, which calls to a celciusToFahrenheit function:

--------------------------------------------------------------------------------------------------------------

SQL> set serverout on size unlimited;
SQL> exec dbms_java.set_output(2000000);

PL/SQL procedure successfully completed.

SQL> SELECT celciusToFahrenheit(30) from dual;
SELECT celciusToFahrenheit(30) from dual
      *
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception: HTTP transport
error: javax.xml.soap.SOAPException: java.security.PrivilegedActionException:
javax.xml.soap.SOAPException: Bad response: 403 Forbidden
ORA-06512: at "USR.UTL_DBWS", line 404
ORA-06512: at "USR.UTL_DBWS", line 401
ORA-06512: at "USR.CELCIUSTOFAHRENHEIT", line 19

ServiceFacotory: oracle.j2ee.ws.client.ServiceFactoryImpl@78e2087c
WSDL: null
Service: oracle.j2ee.ws.client.BasicService@7e793f13
*** Created service: -584406447 -
oracle.jpub.runtime.dbws.DbwsProxy$ServiceProxy@c717dcc5 ***
ServiceProxy.get(-584406447) =
oracle.jpub.runtime.dbws.DbwsProxy$ServiceProxy@c717dcc5
setProperty(javax.xml.rpc.soap.operation.style, document)
Attribute 0: http://webservices.daehosting.com/temperature: xmlns,
http://webservices.daehosting.com/temperature
createElement(CelciusToFahrenheit,null,http://webservices.daehosting.com/tempera
ture)
Attribute 0: http://webservices.daehosting.com/temperature: xmlns,
http://webservices.daehosting.com/temperature
dbwsproxy.element.node.child.0: 1, null
createElement(nCelcius,null,http://webservices.daehosting.com/temperature)
dbwsproxy.text.node.child.0: 3, 30
request:
<CelciusToFahrenheit xmlns="" title="Click (or CTRL+Click if using Firefox) to view" name="contextTextUrl_1389072439587" target="_blank">http://webservices.daehosting.com/temperature">
<nCelcius xmlns="30" title="Click (or CTRL+Click if using Firefox) to view" name="contextTextUrl_1389072439587" target="_blank">http://webservices.daehosting.com/temperature">30</nCelcius>
</CelciusToFahrenheit>
HTTP transport error: javax.xml.soap.SOAPException:
java.security.PrivilegedActionException: javax.xml.soap.SOAP
Exception: Bad response: 403 Forbidden
       at oracle.j2ee.ws.client.http.HttpClientTransport.invokeImpl(Unknown Source)
       at oracle.j2ee.ws.client.http.HttpClientTransport.invoke(Unknown Source)
       at oracle.j2ee.ws.client.StreamingSender._sendImpl(StreamingSender.java:175)
       at oracle.j2ee.ws.client.StreamingSender._send(StreamingSender.java:112)
       at
oracle.j2ee.ws.client.dii.CallInvokerImpl.directInvoke(CallInvokerImpl.java:705)
       at oracle.j2ee.ws.client.dii.BasicCall.directInvoke(BasicCall.java:692)
       at oracle.j2ee.ws.client.dii.BasicCall.invoke(BasicCall.java:598)
       at oracle.jpub.runtime.dbws.DbwsProxy$CallProxy.invokeProxy(Unknown Source)
       at oracle.jpub.runtime.dbws.DbwsProxy$CallProxy.access$2600(Unknown Source)
       at oracle.jpub.runtime.dbws.DbwsProxy.invokeProxy(Unknown Source)
CAUSE:
javax.xml.soap.SOAPException: java.security.PrivilegedActionException:
javax.xml.soap.SOAPException: Bad response: 403 Forbidden
       at oracle.j2ee.ws.client.http.HttpClientTransport.invokeImpl(Unknown Source)
       at oracle.j2ee.ws.client.http.HttpClientTransport.invoke(Unknown Source)
       at oracle.j2ee.ws.client.StreamingSender._sendImpl(StreamingSender.java:175)
       at oracle.j2ee.ws.client.StreamingSender._send(StreamingSender.java:112)
       at
oracle.j2ee.ws.client.dii.CallInvokerImpl.directInvoke(CallInvokerImpl.java:705)
       at oracle.j2ee.ws.client.dii.BasicCall.directInvoke(BasicCall.java:692)
       at oracle.j2ee.ws.client.dii.BasicCall.invoke(BasicCall.java:598)
       at oracle.jpub.runtime.dbws.DbwsProxy$CallProxy.invokeProxy(Unknown Source)
       at oracle.jpub.runtime.dbws.DbwsProxy$CallProxy.access$2600(Unknown Source)
       at oracle.jpub.runtime.dbws.DbwsProxy.invokeProxy(Unknown Source)
Caused by: javax.xml.soap.SOAPException:
java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Bad
response: 403 Forbidden
       at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:152)
       ... 10 more
Caused by: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Bad response: 403 Forbidden
       at java.security.AccessController.doPrivileged(Native Method)
       at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:148)
       ... 10 more
Caused by: javax.xml.soap.SOAPException: Bad response: 403 Forbidden
       at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:441)
       at oracle.j2ee.ws.saaj.client.p2p.HttpSOAPConnection$PriviledgedPost.run(HttpSOAPConnection.java:905)
       ... 12 more

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.