Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_http.request on ssl site fails with ORA-29024

Bas de KlerkOct 12 2018 — edited Oct 16 2018

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

This post has been answered by Pavel_p on Oct 15 2018
Jump to Answer
Comments
Post Details
Added on Oct 12 2018
11 comments
12,456 views