Re: owa_util.get_cgi_env IP problem

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?

Don't use the function in a SELECT statement, simply assign the value to a PL-SQL variable.

DECLARE
ip_addr VARCHAR2(100);
BEGIN
        ip_addr := OWA_UTIL.GET_CGI_ENV('REMOTE_ADDR'); END;
/

George Credland
mailto:g.credland_at_sheffield.ac.uk Received on Fri Jul 04 1997 - 00:00:00 CDT