SQL & PL/SQL

dear all;

I tried using

select sys_context('Userenv', 'ip_address') from dual;

to obtain my ip address and it is returning a blank, furthermore i tried using

select utl_inaddr.get_host_address('johnp') from dual

and it is giving me the following error below

       *
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

and I give all the required grant to the associated user using

grant execute on utl_inaddr to financecc;

Edited by: user13328581 on Mar 13, 2012 8:06 AM