Re: Utl_inaddr

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 15 Mar 2004 01:55:25 GMT
Message-ID: <h285c.5475$Q2.2552@nwrdny03.gnilink.net>

"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