Hi,
I need to send a secure request by using a basic autentification via the UTL_HTTP package to Web service which uses a HTTPS ressource
I have read that to allow this we should some configuration should be done :
- Get the root certificate(s) from the browser
- Create a wallet in the Oracle server and load the certificate(s)
- Use the wallet and access to the HTTPS ressource.
For example:
EXEC UTL_HTTP.set_wallet('file:/u01/app/oracle/admin/DB11G/wallet', Pwd);
Then:
-- Make a HTTP request and get the response.
l_http_request := UTL_HTTP.begin_request(''https://gb.redhat.com/');
-- Use basic authentication
UTL_HTTP.set_authentication(l_http_request, p_username, p_password);
l_http_response := UTL_HTTP.get_response(l_http_request);
As we forcast to deploy the access to this HTTPS ressource in many databases, so we should configure the Wallet in each database server , and knowing that the certificates have an expiration dates ..thus it is a quite a heavy method to deploy and specially to maintain this solution.
Is there another way to send secure request from Oracle using a basic autentication to the site without using a Wallet/certificates?
Thanks and Regards