I want to access a web-service from a PL/SQL procedure (using UTL_HTTP) from a 11g R2 db. However, before doing anything, I need to give access to the web-service by adding the web-service to the access control list (ACL).
The web-service I want to test is the open one found here: http://www.service-repository.com/service/overview/-1789095104
This is a free WS you can use to test WS code. The endpoint is http://www.w3schools.com/webservices/tempconvert.asmx
So, adding www.w3schools.com to the ACL list will be fine I think??? Am I correct??
I tried the below method but I get this error and the user guide is not that clear in what to do.
SQL> exec dbms_network_acl_admin.assign_acl(acl=>'temp_ws1.xml', host=>'www.w3schools.com');
BEGIN dbms_network_acl_admin.assign_acl(acl=>'temp_ws1.xml', host=>'www.w3schools.com'); END;
*
ERROR at line 1:
ORA-31001: Invalid resource handle or path name "/sys/acls/temp_ws1.xml"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 94
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 479
ORA-06512: at line 1
Any help would be greatly appreciated.