Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Utl_inaddr
On 14 Mar 2004 00:51:30 -0800, kumar_929_at_yahoo.co.uk (AMIT) wrote:
>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
I don't have access to an 8i instance right now, just 9i and 10g where your code works for me. Try just outputting the value of sys_context('USERENV','IP_ADDRESS') on its own. And try:
select utl_inaddr.get_host_name('<put your IP address here>') from dual
... and see what it does. In other words, start cutting it down into smaller chunks to try and isolate where the problem is.
-- Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>Received on Sun Mar 14 2004 - 05:37:33 CST
![]() |
![]() |