SQL & PL/SQL

Hi to everyone! I'm new one and trying to experiment with consuming web services from database.

I'm trying to consume a (simple) soap web service with utl_http over https with no luck in Oracle Database 11g Release 11.2.0.1.0 - 64bit Production.

When trying to consume a soap web service with utl_http over http I have a great solution. But the things goes bad when the protocol change to secure http (https).

There are a lot of examples and articles out there on how to do that, but there is nothing, not an integrated solution explained step by step.

Let me write down the steps that I have followed so maybe someone will find what am I missing or what am I doing wrong.

1. Grant utl_Http permissions to user.

2. Confure ACLs with

BEGIN

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl  => 'utl_http.xml',

                                    host => 'oracle-base.com');

END;

/

COMMIT;

and check ACLs with

SELECT *

FROM   user_network_acl_privileges;

and

SELECT *

FROM   dba_network_acls;

3. Export certifications from sites web service and import them into wallet (https://oracle-base.com/articles/misc/utl_http-and-ssl). Trying a numner of times with different key types - extensions (with key chains or not)

4. When trying to consume soap web service over HTTPS with SOAP UI everything works great, but with utl_http i get

ORA-28857: Unknown SSL error

I believe keystore loaded successfully but there is a thing missing in my puzzle. Also I find that wallet when execute SELECT *  FROM v$encryption_wallet has a staus closed.

WRL_TYPE   WRL_PARAMETER                      STATUS

The web service trying to execute is a simple add you can fid it https://oracle-base.com/webservices/server.php/ws_add

Please help me to find out what am I doing wrong.

Thank you in advance.