My Oracle Support Banner

Configuring Wallet Manager To Enable HTTPS Connections Via UTL_HTTP.REQUEST (Doc ID 169768.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

Advanced Networking Option - Version 8.1.5 to 11.2.0.1 [Release 8.1.5 to 11.2]
Information in this document applies to any platform.

Purpose

This article has been written to address the following errors that can be encountered when trying to use UTL_HTTP.REQUEST with a URL that is of type HTTPS :

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_HTTP", line 174
ORA-06512: at line 1

or for Oracle9i and higher

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1556
ORA-XXXXX:
ORA-06512: at line 1

Note that the line number for the first ORA-06512 is line 174 or 1556. If this is reported as any other number it is unlikely that the information reported will be useful in resolving.

<Bug 1938667>, <Bug 1960954> and <Bug 1978066> are all related to this problem and are all closed as 'not a bug' since the error is raised due to incorrectly specifying options to UTL_HTTP.REQUEST in conjunction with the certificate provided within the wallet manager.

Scope

The article has been written to address RDBMS versions 8.1.6.x and 8.1.7.x as these both use V2.1 of Wallet Manager. Starting with Oracle9i newer versions of Wallet Manager are being used and ,whilst this article can still be used for configuration,  the error messages reported have been improved to recognise what part of the SQL is incorrect (as reported earlier).

It has also been written to assume no knowledge of OAS/9iAS and is solely to address the first stage of being able to test that we can access the HTML source of the webpage via a SQLPlus session.



The article describes how to set up UTL_HTTP.REQUEST and the wallet manager for a generic website. By making appropriate changes it should be able to extend to any website that the customer has 'https' access to. A main point to note is that if there is a browser on the server that can't access the URL we will not be able to make calls via this mechanism. The article is not intended to describe the HTTPS/SSL mechanism in any detail or why it might be required.



A final point is that since Netscape browsers are not capable of allowing the export of the required 'certificates' that will be then stored in 'Wallet Manager' it is necessary to use any version of Microsoft Internet Explorer.



Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.