UTL_DBWS Call Using NTLM Authentication Causes SOAPException (Doc ID 751995.1)

Last updated on MARCH 15, 2017

Applies to:

Web Services - Version 10.1.3.0.0 to 10.1.3.3.0
Information in this document applies to any platform.
***Checked for relevance on 05-Jun-2013***


Symptoms

You are developing a PL/SQL package to perform a web service callout using Oracle UTL_DBWS supplied package. Microsoft's Internet Information Server (IIS) resides as a proxy server between the data server and the application server which hosts the called web service. The IIS has windows integrated security activated which is based on NTLM authentication. If the service is not passed through IIS, the callout works fine. When the service is secured by passing through IIS, the following error message is seen:

ORA-29532: HTTPtransport error: javax.xml.soap.SOAPException: 
java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message 
send failed: HTTPClient.AuthSchemeNotImplException: NTLM 

 An example invocation:

SYS.UTL_DBWS.SET_PROPERTY(l_call,'USERNAME','abc.server.us\AMDLM');
SYS.UTL_DBWS.SET_PROPERTY(l_call,'PASSWORD','AMDLM');
l_result_XML := SYS.UTL_DBWS.invoke (l_call,evXML_Server);

Since the authentication is based on NTLM, research shows an Oracle Java API - HTTPClient.ntlm:
http://download.oracle.com/docs/cd/B31017_01/web.1013/b32117/index.html

However there is no documentation stating how to incorporate this using the UTL_DBWS package.

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