Oracle Database Discussions

Hi to all,

I want to call an HTTPS site via pl/sql using the UTL_HTTP package.

I have implemented the following standard steps to call an HTTPS site:

1. Create Oracle Wallet with orapki command
2. Add the certificate chain to Oracle Wallet
3. Call the HTTPS site. In particular the https://www.oracle.com site.

But I get the error: ORA-28759 - failure to open file.

Following I show you the code:

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
C:\Users\SVILUPPO>cd /d E:
E:\>orapki wallet create -wallet E:\test\wallet -pwd oracle123 -auto_login
Oracle PKI Tool : Version 11.2.0.2.0 - Production
Copyright (c) 2004, 2010, Oracle and/or its affiliates. All rights reserved.
E:\>orapki wallet add -wallet E:\test\wallet -cert E:\test\GeoTrustGlobalCA.crt -trusted_cert -pwd oracle123
Oracle PKI Tool : Version 11.2.0.2.0 - Production
Copyright (c) 2004, 2010, Oracle and/or its affiliates. All rights reserved.
E:\>orapki wallet add -wallet e:\test\wallet -cert e:\test\GeoTrustSSLCA-G3.crt -trusted_cert -pwd oracle123
Oracle PKI Tool : Version 11.2.0.2.0 - Production
Copyright (c) 2004, 2010, Oracle and/or its affiliates. All rights reserved.
E:\>sqlplus CKS_TGW
SQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 1 15:56:40 2016
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
SQL> set serverout on
SQL> set define off
SQL> declare
  2  req  UTL_HTTP.req;
  3  resp UTL_HTTP.resp;
  4  BEGIN
  5  UTL_HTTP.SET_WALLET ('file:E:\test\wallet','oracle123');
  6  req := UTL_HTTP.begin_request('https://www.oracle.com');
  7  dbms_output.put_line(resp.status_code);
  8  UTL_HTTP.end_response(resp);
  9  END;
 10  /
declare
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-28759: failure to open file
ORA-06512: at line 6
SQL>

Please, can anyone help me to resolve this oracle error?

Thanks in advance!