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
----------------------------
Using UTL_HTTP and an Oracle Wallet to Establish a Secure URL Connection (SSL) — (13-September-2010)