Getting IP address of client

From: Mike Layng <mlayng_at_micomine.com.au>
Date: Fri, 9 Oct 1998 12:43:40 +0800
Message-ID: <6vk4bl$k2o$1@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 receiveing 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 Thu Oct 08 1998 - 23:43:40 CDT