Re: Getting IP address of client

From: Mike Layng <mlayng_at_micomine.com.au>
Date: Mon, 12 Oct 1998 08:32:27 +0800
Message-ID: <6vriol$1fb$1@yeppa.connect.com.au>

Hi Russ,

Thanks for the reply.

The code I tried was almost identical to what you suggest (i think i had varchar2(20) instead of varchar2(15)), but I still get that exception.

Can anyone tell me if exception ORA06502 would fire if the get_cgi_env was returning NULL?

Thanks,
Mike.

R Fray wrote in message <361e069d.14705422_at_news.u-net.com>...
>
>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.
>

mlayng_at_micromine.com.au Received on Sun Oct 11 1998 - 19:32:27 CDT