I'm new to Oracle PL/SQL Development and I need to call few 3rd party REST APIs (Through https) from Oralce SQL Developer using `UTL_HTTP` package. When calling an API, Oracle shows the following error message...
*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 there certificate has failed, or resend.
So I guess that, since the call is https; we need to add this SSL certificate to Oracle Wallet before calling the API.
Which certificate that we should add to the wallet? Is it the certificate that we could download using our browser as a *.cer file?
Clicking padlock icone --> Connections--> Certificate Information --> Export
Even I've added this certificate to wallet its not working and giving the above arror.
Note: We are using Oracle 11g and use Oralce SQL Developer for calling APIs. Also we have enabled internet access in our Oracle testing envoronment.
This is a sample API request
req := UTL_HTTP.BEGIN_REQUEST('https://www.example.com/api/job/all', 'GET', 'HTTP/1.1');
Any thoughts?