Requirement : To pull the data from the ASP.NET Webservice into Oracle DB
Approach : Consume ASP.NET Webservices(SOAP-based) Response into ORACLE DB using PL/SQL(utl_http OR utl_DBWS).
The ASP.Net uses Integrated Windows Authentication( NTLM/Kerboros Authentication) over SSL. When try to access the webservice with anonymous access it works, but either with NTLM/Kerboros or SSL it fails. We have used sys.utl_http.set_authentication(http_req,<<username>>,<<password>>,'Basic',false) , but still no use
Completed POC Activities
-> We were able to access .Net Web Service using PL/SQL (utl_http) without any Security Restrictions( Anonymous Access )
Unable to to the following operations
-> Access .NET Web Service using PL/SQL (utl_http) with Integrated Security Enabled ( NTLM/ Kerboros Authentication)
-> Access .NET Web Service using PL/SQL (utl_http) with Integrated Security Enabled ( NTLM/ Kerboros Authentication) over SSL
Need help in writing the Pl/SQL code to access Asp.net web Service with Integrated Windows Authentication( NTLM/Kerboros Authentication) over SSL.