My Oracle Support Banner

ORA-24247 When Executing UTL_HTTP UTL_INADDR Packages (Doc ID 453786.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1 to 11.2]
PL/SQL - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 14-Feb-2014


When executing DBMS_LDAP, UTL_INADDR (or) UTL_HTTP (or) any UTL packages after upgrading to 11gR1, fails with following error.

        l_url varchar2(32767);
        l_conn utl_http.req;
        l_url := '';
        l_conn := utl_http.begin_request(url => l_url, method => 'POST', http_version=> 'HTTP/1.0');
        dbms_output.put_line('Anonymous Block Executed Successfully');

ERROR at line 1:
ORA-29273: HTTP request failed
ORA-6512: at "SYS.UTL_HTTP", line 1029
ORA-24247: network access denied by access control list (ACL)
ORA-6512: at line 6

SQL> select utl_inaddr.get_host_address('') from dual;
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


Support, DataBase Administrators, Developers


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.