ACL Creation for Getting Client Machine Name in Oracle Apex

 BEGIN

  DBMS_NETWORK_ACL_ADMIN.create_acl(

    acl         => 'resolve_acl_fbrinv.xml',

    description => 'ACL to allow DNS resolution',

    principal   => 'FBRINV',  -- Replace with your actual user

    is_grant    => TRUE,

    privilege   => 'connect'

  );

  DBMS_NETWORK_ACL_ADMIN.assign_acl(

    acl  => 'resolve_acl_fbrinv.xml',

    host => '*'

  );

END;

/

/********************************************************************************/

select utl_inaddr.get_host_name(owa_util.get_cgi_env('REMOTE_ADDR')) into :pageitem from dual;