URGENT - owa_util.get_cgi_env('REMOTE_ADDR')

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.

[Quoted] 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'); DBMS_OUTPUT.PUT_LINE(IP_ADDRESSA);
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 - 08:54:35 CEST