owa_util.get_cgi_env does not have HTTP

From: <crooneycbs_at_my-dejanews.com>
Date: Wed, 07 Apr 1999 14:57:37 GMT
Message-ID: <7efrot$5kp$1@nnrp1.dejanews.com>

All,

How do I get the HTTP_HOST from within pl/sql? It would appear that the Oracle Web Request Broker calls owa.init_cgi_env at some point with a select set of environment vars, but not all of them. Below is a list of what I get from owa_util.print_cgi_env. I know i'm getting the full set of env vars from my webserver (Netscape) because i can see them in CGI progs, but the web broker doesn't seem to get them to the pl/sql cartridge.

Is there a way to force the wrb to pass along HTTP_HOST or another way to get the value? I can't just use the ip address because we have multiple domains that resolve to the same one. Using the HTTP_REFERER won't work if the url is bookmarked or pasted in. Using dbms 7.3.3 wrb 3.02 netscape 3.5.1.

Thanks in advance,
chris
cjrooney at cbs dot com

SERVER_SOFTWARE = Netscape-Enterprise/3.5.1G SERVER_NAME = host3-cbs.teb1 GATEWAY_INTERFACE = CGI/1.1 REMOTE_HOST = 170.20.77.145 REMOTE_ADDR = 170.20.77.145 HTTP_ACCEPT = application/vnd.ms-excel, application/msword, application/vnd.ms- powerpoint, image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, */* HTTP_USER_AGENT = Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) SERVER_PROTOCOL = HTTP/1.1 SERVER_PORT = 80 SCRIPT_NAME =
/prd1/now PATH_INFO = /biff PATH_TRANSLATED =
/opt/app/oracle/product/ows302/ows/3.0/bin/biff HTTP_COOKIE = zipcode

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 09:57:37 CDT

owa_util.get_cgi_env does not have HTTP_HOST