APEX

I am using databsae 18.4.0.0.0

Apex 18.2

I have set acces control as:

select acl, principal, privilege is_grant from dba_network_acl_privileges;

ACL                                            PRINCIPAL      IS_GRANT

----------------------------------------    ---------      -------------

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  EBTEST       resolve

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  APEX_180200  resolve

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  SYS          resolve

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  SYSTEM       resolve

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  APEX_180200  connect

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  EBTEST       connect

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  SYS          connect

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  SYSTEM       connect

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  APEX_180200  http

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  EBTEST       http

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  SYS          http

NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB  SYSTEM       http

select host, lower_port, upper_port, acl from dba_network_acls;

HOST                           LOWER_PORT UPPER_PORT   ACL

*                                    (NULL)              (NULL)                NETWORK_ACL_787D0D2B97286933E0530CAAE80A12FB

Within APEX this works fine:

Declare

   l_clob         clob;

BEGIN

   l_clob := apex_web_service.make_rest_request (

             p_url => 'http://jsonplaceholder.typicode.com/todos/1',

             p_http_method => 'GET'

             );

   return l_clob;

END;

This does not and thgrows the above error:

Declare

  l_url          VARCHAR2(50) := 'http://jsonplaceholder.typicode.com/todos/1';

  l_http_request   UTL_HTTP.req;

  l_http_response  UTL_HTTP.resp;

Begin

  l_http_request   := UTL_HTTP.begin_request(l_url);

  l_http_response  := UTL_HTTP.get_response(l_http_request);

  UTL_HTTP.end_response(l_http_response);

end;

Full error:

Ora_sqlerrm: ORA-29273: HTTP request failed

ORA-06512: at "APEX_180200.WWV_FLOW_DYNAMIC_EXEC", line 2465

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

ORA-06512: at "SYS.UTL_HTTP", line 380

ORA-06512: at "SYS.UTL_HTTP", line 1148

ORA-06512: at line 6 ORA-06512: at line 10

ORA-06512: at "SYS.DBMS_SQL", line 1721

ORA-06512: at "APEX_180200.WWV_FLOW_DYNAMIC_EXEC", line 2450

ORA-06512: at "APEX_180200.WWV_FLOW_DYNAMIC_EXEC", line 1309

Anyone any ideas?  This is my first ever post so appologies for any sins of omission