Re: Utl_inaddr

From: AMIT <kumar_929_at_yahoo.co.uk>
Date: 14 Mar 2004 00:51:30 -0800
Message-ID: <6f94b59f.0403140051.369e1207@posting.google.com>

Hi Andy,

I am using version 8.1.7.0.
I still got the same error.

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

Code:

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;

Andy Hassall <andy_at_andyh.co.uk> wrote in message news:<vim650d70n4u3ms233rd4vtmv73icgdnsa_at_4ax.com>...
> On 11 Mar 2004 23:34:43 -0800, kumar_929_at_yahoo.co.uk (AMIT) wrote:
>
> >After running the following Pl/SQl block I am getting the following error.
> >Could some one suggest about it what’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
> >
> >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;
> >/
>
> Works fine for me, code unchanged from your post:
>
> Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
> Connected as test
>
> SQL> set serveroutput on
> SQL>
> SQL> declare
> 2 v_gname varchar2(256);
> 3 begin
> 4 select global_name into v_gname from global_name;
> 5 dbms_output.put_line('User: '||user);
> 6 dbms_output.put_line('Database: '||v_gname);
> 7 dbms_output.put_line('Client IP: '||
> 8 sys_context('USERENV','IP_ADDRESS'));
> 9 dbms_output.put_line('Client Name: '||
> 10 utl_inaddr.get_host_name(sys_context('USERENV','IP_ADDRESS')));
> 11 dbms_output.put_line('DB Server IP: '||utl_inaddr.get_host_address);
> 12 dbms_output.put_line('DB Server Name: '||utl_inaddr.get_host_name);
> 13 end;
> 14 /
> User: TEST
> Database: DEV101
> Client IP: 192.168.1.14
> Client Name: excession.localhost
> DB Server IP: 127.0.0.1
> DB Server Name: testbox.localhost
>
> PL/SQL procedure successfully completed
>
>
> Your Oracle version is?
>
> Try:
>
> SQL> desc utl_inaddr.get_host_name;
> Parameter Type Mode Default?
> --------- -------- ---- --------
> (RESULT) VARCHAR2
> IP VARCHAR2 IN Y
>
> Does your version, for some reason, have a differing argument list? Perhaps it
> changed in some version.
Received on Sun Mar 14 2004 - 02:51:30 CST