AMIT wrote:
> 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’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.
I have working demos of UTL_INADDR at:
http://www.psoug.org/reference/library.html
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Mar 12 2004 - 11:19:19 CST
