Newsletters Archive - 2010

If you would like to know more about the iDevelopment.info Newsletter, please email me.


  Using UTL_HTTP and an Oracle Wallet to Establish a Secure URL Connection (SSL) — (13-September-2010)

An article describing the steps necessary to establish a secure URL connection 
(SSL) using the UTL_HTTP Oracle PL/SQL package and an Oracle Wallet. In order 
to fully demonstrate the required steps, I will be establishing a secure URL 
connection to the web site https://www.centos.org/ from within PL/SQL.

In order to establish a connection to a secure URL from an Oracle database 
server, the following tasks will need to be performed:

    * Capture all required certificates from the SSL site
    * Create an Oracle Wallet that is accessible on the database server
    * Import the required certificate(s) of the SSL site into the Oracle Wallet
    * Use the UTL_HTTP.SET_WALLET PL/SQL procedure before attempting to access the secure URL

The full article can be found at:

Using UTL_HTTP and an Oracle Wallet to Establish a Secure URL Connection (SSL)

----------------------------
Jeffrey M. Hunter, OCP
Sr. Database Administrator
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------