Hello ,
Looking for support , we are invoking below API from oracle database (19c OCI) , when we are calling we get the issue for certificates.
SET SERVEROUTPUT ON;
DECLARE
v_ws_url VARCHAR2(200) := 'https://services.pps.edenred.com/wschopinapi/services/wschopin'; -- can be replaced by the test URL
v_wallet_name VARCHAR2(200) := '/u02/app/oracle/product/owm/wallet/CFM01/KKS'; -- path of the wallet file defined on the DB server
http_req utl_http.req;
BEGIN
IF v_wallet_name IS NOT NULL THEN -- https web service, load the SSL certificates
utl_http.set_wallet('file:' || v_wallet_name, v_wallet_password);
END IF;
http_req:= utl_http.begin_request(v_ws_url,
'POST',
'HTTP/1.1');
END;
ISSUE :
ORA-29024: Certificate validation failure
Certificates are exported from URL and valid and installation was also with sucess . Is there any change for certificates (wallet ) with 19c. We installed in different format like p7c , and others but not helping.
also removed “_” from wallet and tried but no luck .
Anyone can help if something I missed to try or I should try something else.
Thank you