Re: Utl_inaddr

Hi,Daniel Morgan

I think the parenthesis is correct.

 dbms_output.put_line('Client Name:
'||utl_inaddr.get_host_name(sys_context('USERENV','IP_ADDRESS')));

Could you plz check it?

Thanks

Amit

<damorgan_at_x.washington.edu> wrote in message news:<1079077597.344257_at_yasure>...
> AMIT wrote:
>
> > Hi,
> >
> > After running the following Pl/SQl block I am getting the following error.
> > Could some one suggest about it what&#8217;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
> >
> >
> >
> > Regards
> >
> > Kumar
>
> Count your parenthesis.
Received on Fri Mar 12 2004 - 10:23:06 CST