Search notes:

ORA-24247: network access denied by access control list (ACL)

Allow user RENE to use utl_http to connect to and resolve the host renenyffenegger.ch:
begin
   dbms_network_acl_admin.append_host_ace(
     host => 'renenyffenegger.ch',
     ace  =>  xs$ace_type(
        privilege_list => xs$name_list('connect', 'resolve'),
        principal_name =>'rene',
        principal_type => xs_acl.ptype_db
     )
   );
end;
/

See also

ORA-29273: HTTP request failed
utl_http
Other Oracle error messages

Index