Hello all,
I'm trying to communicate with the an HTTPS endpoint via PL/SQL (Oracle 12.2).
I'm facing a Certificate validation failure:
"
ORA-29024 - "Certificate validation failure"
*Cause: The certificate sent by the other side could not be validated. This may occur if
the certificate has expired, has been revoked, or is invalid for another reason.
*Action: Check the certificate to determine whether it is valid. Obtain a new certificate,
alert the sender that the certificate has failed, or resend.
"
I create a wallet and add the certificate chain to the wallet with the orapki command.
In my code I declare the wallet with UTL_HTTP.set_wallet.
I use the utl_http.begin_request function to communicate with https://api.hubapi.com/deals/v1/deal/paged?portalId=3430672 (example).
In the browser i'm able to do the request.
I dowloaded the certificate from the browser just as I did with other servers (oracle.com for example), but with this endpoint I get this error in the plsql call.
Can someone please help?
Thanks in advance