Re: Where is QUERY_STRING var ?

A copy of this was sent to Wassim <net2000_at_francemel.com> (if that email address didn't require changing) On Sat, 22 May 1999 16:26:48 GMT, you wrote:

>i'm using Oracle WebServer 3.0 and have to make an application in which
>i need access to the QUERY_STRING CGI variable, using the
>owa_util.get_cgi_env('QUERY_STRING') return always NULL,
>owa_util.print_cgi_env did not print QUERY_STRING nor REQUEST_METHOD
>where it's supposed to do,
>does anyone have idea?
>thanx.
>

The are both left out since if you call a URL with:

http://hostname/dcd/owa/some_Procedure?x=5&y=10

you *must* have a procedure:

create procedure some_procedure( x in varchar2, y in varchar2 ) ....

It doesn't matter at all if you POST or GET this URL -- it will still be a stored procedure call with x and y as input parameters.

The query string is redundant -- you must have had a procedure "some_procedure" with inputs X and Y.

the Request Method is dealt with for you (get and post are processed). As well, the POST'ed or QUERY_STRING data is parsed, url decoded, and passed as formal input parameters.

If you *really* need the query string, you can always construct it from the inputs. for example if the first line of some procedure is:

   query_string := 'x=' || ltrim(x) || '&y=' || ltrim(y);

>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat May 22 1999 - 13:30:09 CDT