XE owa_sec.GET_CLIENT_HOSTNAME problem

#1 (**permalink**) 02-25-2008, 09:09 AM

All,

I am experimenting with mod pl/sql at the moment on a oracle XE
installation. I have written a simple page which I want to output the
users host name and IP address:

create or replace PROCEDURE GET_HOST_NAME AS
BEGIN

htp.print( '<html>
<head>
<title>IP NAME</title>
</head>
<body>
Your IP name is ' || nvl(owa_sec.GET_CLIENT_HOSTNAME,
'NULL') );
htp.print( '</body>
</html>');

END;

The HTML output I get is:
Your IP name is NULL.

I have tried metalink article 150089.1, and reinstalled pubowa.sql,
privowa.sql, pubcust.sql and privcust.sql, from the RDBMS directory of
my XE installation, after logging in as sys.

Why is the owa_sec.get_client_hostname not working?

Regards,
Graham

#2 (**permalink**) 02-25-2008, 09:09 AM

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') );

--
Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond

#3 (**permalink**) 02-25-2008, 09:10 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode