APEX

Hello

I wish to run ...

select httpuritype('' || URL_NAME ||'').getblob() into value from dual;

I getting ACL error ....

ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1130
ORA-24247: network access denied by access control list (ACL)

I tries a number of ACL combinations without success e.g.

begin
dbms_network_acl_admin.create_acl (
acl => 'utl_http.xml',
description => 'HTTP Access',
principal => 'xxxxx',
is_grant => TRUE,
privilege => 'resolve',
start_date => null,
end_date => null
);
end;

What should I be doing?

All help welcome

Regards

Pete