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>