Hi,
This question is more db related then apex but I think the most knowledge related to https from the db is probably this place.
I've tried this on version 11.2, 12.1 and 12.2
Since a short time an interface used from an apex app is failing.
A short example of what fails is below, I think the problem is related to the server where the request is send to since other ssl sites don't have this issue.
We try to open an ssl connection to a site but it fails with ORA-29024 ( validation of certificate failed ).
The root certificate of the site ( which is entrust.net ) is installed in the wallet.
I've tried to create a clean new wallet, import the entrust root certificate which I downloaded from the site which I try to access. But after doing a utl_http.request it fails.
Any insights on why this goes wrong, maybe a specific protocol version which is not supported or do I need to do some additional stuff for this entrust cert ?
declare
l_dummy varchar2(32000);
begin
UTL_HTTP.set_wallet('file:d:\<<wallet location>>\', '<<wallet password>>');
SELECT utl_http.request('https://login.twinfield.com/') into l_dummy from dual;
end;
Hope someone can point me in the right direction how to solve this.
Regards
Bas