8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

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.

Tim... said...

Hi.

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.

Cheers

Tim...

Steve said...

when executing:

SET SERVEROUTPUT ON
EXEC UTL_HTTP.set_wallet('file:/wallet2', 'xxxxxxxxx');
EXEC show_html_from_url('https://gb.redhat.com/');

I get ORA-28759: failure to open file.

any ideas?

Thanks

Tim... said...

Hi.

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.

Cheers

Tim...

Anna Rossi said...

Can you please specify the minimum Oracle DB version which can use this methos?

Tim... said...

Hi.

The first sentence says, "Since Oracle 9i Release 2...". :)

Cheers

Tim...

Edward Girard said...

Both links for the "orapki Utility" and "UTL_HTTP" no longer work.

Tim... said...

Hi.

Oracle just love changing their URLs. I've fixed them now. Thanks for the heads up!

Cheers

Tim...

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!