Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: owa_util.get_cgi_env IP problem
Do not bet on using this long term. If you want to get a idea of the address from the user, use 'REMOTE_ADDR'. This returns the remote host destination. If the user sits behind a proxy server, you'll get the provy server address. To set you mind at ease, if you still wants to, do the following within a PL/SQL.
Function get_ip return varchar2
in_ip varcahr2(100) := owa_util.get_cgi_env('REMOTE_ADDR');
begin
return (in_ip);
end;
But, by the way, came across a nice article on the types of HTTP calls
in a CGI enviornment, cheers to it,
http://www.macon.tec.ga.us/cfdocs/userguid/ap2.htm .
Q. There is a call using 'HTTP_FROM', anybody with any success with
this. The call fetches the email address of the user.
Terrence Wong
Systems Developer
Nico Jacobs wrote:
> Hello there,
>
> if I try to use the function owa_util,get_cgi_env, via webserver 2.1,
> I get this error:
>
> login:(-6571) ORA-06571: Function GET_CGI_ENV does not guarantee not
> to update database.
>
> I try to get the IP address of the remote computer, for security
> reasons.
> Do you know how to solve this, or another way to do it?
>
> Thanks.
> Please also reply to nicoj_at_ai.aiesec.org
>
> Nico Jacobs
Received on Mon Jul 07 1997 - 00:00:00 CDT