IF OWA.num_cgi_vars IS NOT NULL
         THEN
            -- PL/SQL gateway connection (WEB client)
            v_ip := OWA_UTIL.get_cgi_env ('REMOTE_ADDR');
         ELSE
            -- Direct connection over tcp/ip network
            v_ip := SYS_CONTEXT ('USERENV', 'IP_ADDRESS');
         END IF;