Re: XE owa_sec.GET_CLIENT_HOSTNAME problem

From: Graham Wallace <graham.wallace_at_NOSPAM.blueyonder.co.uk>
Date: Sat, 28 Oct 2006 06:31:38 GMT
Message-ID: <ePC0h.111920$3D1.50775@fe3.news.blueyonder.co.uk>

HansF wrote:
> On Fri, 27 Oct 2006 22:52:59 +0000, Graham Wallace wrote:
>
>

>>                Your IP name is ' || nvl(owa_sec.GET_CLIENT_HOSTNAME, 
>> 'NULL') );

>
> Curious - what happens wen you change this line to:
>
>
> Your IP name is ' || nvl(sys_context('USERENV','HOST'), 'NULL') );
>

It prints out:

Your IP name is NULL Received on Sat Oct 28 2006 - 01:31:38 CDT