Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Utl_inaddr
"AMIT" <kumar_929_at_yahoo.co.uk> wrote in message
news:6f94b59f.0403140051.369e1207_at_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
>
Just do a desc on utl_inaddr and you would know your answer. In 8i it does not take any parameters.
or just read the utlinad.sql in rdbms/admin ....
Anurag Received on Sun Mar 14 2004 - 19:55:25 CST
![]() |
![]() |