Re: URGENT - owa_util.get_cgi_env('REMOTE_ADDR')

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Tue, 8 Oct 2002 11:01:55 +0200
Message-ID: <3da29efe$0$18699$edfadb0f_at_dspool01.news.tele.dk>


Hi there.

How are you calling the stored procedure from your form? Directly from PL/SQL? Then the stored procedure is invoked directly, not involving iAS, thus not setting up the PL/SQL Web Toolkit with CGI variable values, etc. If from PL/SQL using a URL this will probably be executed on the iAS, not on the client. So you need some mechanism of obtaining the client's IP address, probably through some Java code running in the form on the client. You can specialize the look and feel of the form so I guess you can inject other Java code as well.

Hope this helps.

Finn

"Natron" <aa> wrote in message news:antvb0$e8818_at_ns4.bih.net.ba...
>
> Please, can you guide me to get correct IP address of workstation running
> Oracle Form in the browser using owa_util package.
>
> This is database procedure that I call from Oracle Form.
>
> create or replace procedure get_ip(IP_ADDRESS OUT VARCHAR2) is
> name_arr OWA.VC_ARR;
> value_arr OWA.VC_ARR;
> BEGIN
> OWA.INIT_CGI_ENV(0, NAME_ARR, VALUE_ARR);
> Ip_address:=OWA_UTIL.GET_CGI_ENV('REMOTE_ADDR');
> END;
>
> I always get null instead of IP address
>
> Please can you tell me where is mistake.
>
> Oracle database - 9.0.1
> Application server - IAS 9i R2
>
>
> Thank you very much
>
>
>
>
>
Received on Tue Oct 08 2002 - 11:01:55 CEST

Original text of this message