Re: Getting IP address of client

Hi, If you define a variable as :

        vipaddress varchar2(15);

You should then be able to insert the IP address in to that variable using :

          vipaddress := owa_util.get_cgi_env('remote_addr');

This is using Oracle Web Server & PL/SQL but the format is correct. You are getting a type-mismatch, what are you trying to insert the IP into? Make sure it's a character type.

Russ.

>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
>
>
>
>

--

Russell Fray
U-NET Ltd. Received on Fri Oct 09 1998 - 07:52:02 CDT