Certificate Error When Calling Rest Service with APEX_WEB_SERVICE / UTL_HTTP

(Doc ID 2339601.1)

Last updated on MARCH 29, 2018

Applies to:

Oracle Application Express (APEX) - Version 4.2 to 5.1.3 [Release 4 to 5]
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.

Symptoms

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?

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