Hi,
Our team wants to call a webservice from a pl sql procedure but at first we need to setup ACL to access webservice, so we executed the following block:
begin
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('ondemand.xml', 'Permite el uso de paquetes de red UTL', 'FVLCRM', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE( 'ondemand.xml', 'FVLCRM', true, 'resolve');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL( 'ondemand.xml', 'url given to us to execute webservices');
END;
/
COMMIT;
Procedure CREATE_ACL and ADD_PRIVILEGE work but ASSIGN_ACL does not work, we get an error about wrong host, although the request using SOAPUI works. So it is posible that we should add user credentials to ASSIGN_ACL method? the soap request at the header section has user an password.
Thanks.