Utl_inaddr

From: AMIT <kumar_929_at_yahoo.co.uk>
Date: 11 Mar 2004 23:34:43 -0800
Message-ID: <6f94b59f.0403112334.5f57543f@posting.google.com>

Hi,

After running the following Pl/SQl block I am getting the following error. Could some one suggest about it what&#8217;s wrong in it?

utl_inaddr.get_host_name(sys_context('USERENV','IP_ADDRESS'))); *
ERROR at line 10:

ORA-06550: line 10, column 2:
PLS-00306: wrong number or types of arguments in call to 'GET_HOST_NAME'
ORA-06550: line 9, column 2:

PL/SQL: Statement ignored

Regards

Kumar

declare
v_gname varchar2(256);
begin
 select global_name into v_gname from global_name;

 dbms_output.put_line('User: '||user);
 dbms_output.put_line('Database: '||v_gname);
 dbms_output.put_line('Client IP: '||

 sys_context('USERENV','IP_ADDRESS'));
 dbms_output.put_line('Client Name: '||
 utl_inaddr.get_host_name(sys_context('USERENV','IP_ADDRESS')));  dbms_output.put_line('DB Server IP: '||utl_inaddr.get_host_address);  dbms_output.put_line('DB Server Name: '||utl_inaddr.get_host_name); end;
/ Received on Fri Mar 12 2004 - 01:34:43 CST