owa_util.get_cgi_env IP problem

Nico Jacobs

unread,

Jul 4, 1997, 3:00:00 AM7/4/97

to

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 ni...@ai.aiesec.org

Nico Jacobs

Josef Huber

unread,

Jul 5, 1997, 3:00:00 AM7/5/97

to

You couldn't use get_cgi_env in a SELECT statement
Try this

DECLARE
v_remote_addr VARCHAR2('40');
BEGIN
v_remote_addr := owa_util.get_cgi_env('REMOTE_ADDR');
END;

Nico Jacobs <nja...@bigfoot.com> schrieb im Beitrag
<33BCDE6C...@bigfoot.com>...

Terrence Wong

unread,

Jul 7, 1997, 3:00:00 AM7/7/97

to

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