Comments for UTL_HTTP and SSL (HTTPS) using Oracle Wallets
Tony Reed said...Hi,
the example will not work on Oracle 12.1
According to Oracle Support only the certificate chain should be imported, not the end site certificate.
I.e. In the example you use, only import these:
Builtin Object Token:GTE CyberTrust Global Root
Akamai Subordinate CA
If the third certificate, *.redhat.com, is imported utl_http throws a Certificate validation failure at you.
Yes. I just did a run through to check and I get the same issue as you. I will amend the article to make sure this is clear.
It works fine with just the chain, not the end entry on 11.2 and 12.1.
Steve said...when executing:
SET SERVEROUTPUT ON
EXEC UTL_HTTP.set_wallet('file:/wallet2', 'xxxxxxxxx');
I get ORA-28759: failure to open file.
Either you've done the setup incorrectly, or the DB server doesn't have access to the internet.
Difficult to know with the lack of information presented. If you want me to help, please post a question in the forum on this site.
Anna Rossi said...Can you please specify the minimum Oracle DB version which can use this methos?
The first sentence says, "Since Oracle 9i Release 2...". :)
Edward Girard said...Both links for the "orapki Utility" and "UTL_HTTP" no longer work.
Oracle just love changing their URLs. I've fixed them now. Thanks for the heads up!
FLAVIO said...Not working inside a procedure. Only in script.
We use it from procedures all the time. It's probably a permissions thing. Make sure the calling use has all the correct permissions, not via a role. An anonymous block can use permissions from a role. A stored procedure (with invoker rights) can not. I bet that is your issue.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!