I have an open SR with support, but it seems to be going nowhere.
I'm trying to connect to an office 365 API in order to read emails.
I saved all the certs from here in a wallet https://login.microsoftonline.com/en
C:\>orapki wallet display -wallet D:\Oracle\Wallets
Oracle PKI Tool : Version 220.127.116.11.0
Copyright (c) 2004, 2016, Oracle and/or its affiliates. All rights reserved.
Enter wallet password:
Subject: CN=Baltimore CyberTrust Root,OU=CyberTrust,O=Baltimore,C=IE
Subject: CN=Microsoft IT TLS CA 4,OU=Microsoft IT,O=Microsoft Corporation,L=Redmond,ST=Washington,C=US
I cannot connect.. I've tried all DNS in alternate names
wallet_loc varchar2(100) := 'file:D:\Oracle\Wallets';
req := UTL_HTTP.REQUEST(url=>' https://login.microsoftonline.com/en',
Error report -
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1501
ORA-24263: Certificate of the remote server does not match the target address.
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1441
ORA-06512: at line 6
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.
Any help would be great. I'm starting to consider using java to call the web service as I'm losing faith in utl_http