select utl_inaddr.get_host_address from dual * ERROR at line 1: ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_INADDR", line 19 ORA-06512: at "SYS.UTL_INADDR", line 40 ORA-06512: at line 1 SQL> Cause...
ORA-24247 NETWORK_ACCESS_DENIED ネットワークへのアクセスが拒否されました。 ORA-29257 UNKNOWN_HOST ホストが不明です。 例 ローカル・ホストの名前とIPアドレスを取り出します。 SET serveroutput on BEGIN DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME); -- get local host name DB...
Access to these packages, UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, UTL_INADDR, must explicitly be granted to users through Access Controls Lists (ACL) ) 如果不授予ACL 权限,那么可能在调用UTL_ 包,碰到如下报错 ORA-24247: network access denied by access control list (ACL) ###2.详细解释如下...