Jump to content
Sign in to follow this  
btidba

How to secure an HTTPS request send from PL/Sql UTL_HTTP package

Recommended Posts

Hi,

I need to send a secure request via the UTL_HTTP package to an HTTPS ressource using a basic autentification.I have read that to allow this:

- Get the root certificate from the browser

- Create a wallet containig this certificate

- 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 this in many databases, is there another way to send secure request from Oracle using a basic autentication to the site without using a certificate?

Thanks and Regards

 

Share this post


Link to post
Share on other sites

Hi,

HTTPS works with certificates, either through Oracle or through Java, or even through our traditional browsers. 

Here is a cool link explaining how it works..

https://robertheaton.com/2014/03/27/how-does-https-actually-work/

 

Thank you,

Boobal Ganesan

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×