Certificate Error When Calling Rest Service with APEX_WEB_SERVICE / UTL_HTTP
Last updated on DECEMBER 14, 2017
Applies to:Oracle Application Express (formerly HTML DB) - Version 4.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database as a Service - Version N/A and later
Information in this document applies to any platform.
When trying to integrate a third party web service with APEX, the request is failing. To verify the web service the following query was executed:
select apex_web_service.make_rest_request('https://www.example.com/api/rest/orders', 'GET') from dual;
Returns the following results:
ORA-29273: HTTP request failed
ORA-24263: Certificate of the remote server does not match the target address.
The certificate was checked in the browser, and www.example.com for the certificate chain in the browser.
What is causing this failure?
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