My Oracle Support Banner

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

Last updated on APRIL 11, 2018

Applies to:

Web Services - Version 10.1.3.0.0 to 10.1.3.3.0
Information in this document applies to any platform.

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.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.