Getting the IP address of a client machine

From: Mike Layng <mlayng_at_micomine.com.au>
Date: Fri, 9 Oct 1998 12:40:19 +0800
Message-ID: <6vk45c$k18$1_at_yeppa.connect.com.au>

Environment: Oracle 8, Developer 2000 R2.1, Oracle Web Server 3.0, NT 4.0.

Hi,
I am developing an application that uses web enabled forms (using Developer 2000 Server).

I want to be able to determine the IP address of a client machine when it accesses the application over the web. Ideally I would like to get the IP address of the actual machine, but the IP of the clients firewall or proxy server will suffice.

I tried using the function "get_cgi_env ('REMOTE_ADDR')" but without success. I kept receiving ORA exception 06502 (data type mismatch or similiar).

I am relatively new to Oracle and very new to the OWS. Any help or ideas would be appreciated.

Thanks,
Mike Layng

mlayng_at_micromine.com.au Received on Fri Oct 09 1998 - 06:40:19 CEST