Re: URGENT - owa_util.get_cgi_env('REMOTE_ADDR')
Date: Tue, 8 Oct 2002 12:36:57 +0400
Message-ID: <anu5jh$n46$1_at_babylon.agtel.net>
Not being proficient with Forms I can't say if you can obtain CGI environment in a form (and if there is any CGI environment), but your code is certainly wrong:
> create or replace procedure get_ip(IP_ADDRESS OUT VARCHAR2) is
> name_arr OWA.VC_ARR;
> value_arr OWA.VC_ARR;
> BEGIN
> OWA.INIT_CGI_ENV(0, NAME_ARR, VALUE_ARR);
Here you just initialized CGI environment to two empty collections. There
is nothing in it then. Subsequent calls to get_cgi_env will return nothing.
You should NEVER call owa.init_cgi_env - PL/SQL gateway (mod_plsql)
does this before calling your stored procedures among other initialization
actions and it is the only place where it can be safely called. This said, I
doubt that Oracle Forms do this, so you probably have to look elsewhere
for the way to obtain client address.
-- Vladimir Zakharychev (bob_at_dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer.Received on Tue Oct 08 2002 - 10:36:57 CEST