When we try to connect external web API or other services from the oracle database or oracle APEX. we may have faced the error network access denied by access control list.
Run Below Code by login as sysdba
BEGIN dbms_network_acl_admin.append_host_ace(host => 'api.docparser.com', lower_port => NULL, upper_port => NULL, ace => xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),principal_name => 'SNDTSTDB', principal_type => xs_acl.ptype_db) ); END;
principal_name --> your schema name