Hello,
I'm trying to make a GET request using the APEX_WEB_SERVICE.make_rest_request function in a REST Data Source, but I'm receiving the following error:
ORA-29024: Certificate validation failure.
The error is intermittent—sometimes the request works fine, but other times, the error occurs. Below are the code I'm using, the error message, and the certificate.
DECLARE
l_response CLOB;
BEGIN
l_response := APEX_WEB_SERVICE.make_rest_request(
p_url => 'https://my_url.com/api/apex/hello-world-teste',
p_http_method => 'GET'
);
DBMS_OUTPUT.PUT_LINE(DBMS_LOB.SUBSTR(l_response, 1000, 1)); -- Print first 1000 characters
END;
This is the error.
This is the certificate that i'm using.
This error started to happen after the update of ORDS to 25.1.0.100.1652 and APEX to 24.2
Can anybody help me in this situation please?