Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
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 - 01:54:35 CDT