Re: Where is QUERY_STRING var ?

In article <374df6f6.11855887_at_newshost.us.oracle.com> tkyte_at_us.oracle.com (Thomas Kyte) writes:

   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.

Yes, certainly, but you might have some default parameters.

create create procedure some_procedure( x in varchar2, y in varchar default '1' ) ...

   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);

... Which isn't true if default parameters are used. You cannot tell whether value came from default or elsewhere. Of course it shouldn't matter where value came from, just being pedantic.

--

• jPj E-Mail: pjuuti@cs.joensuu.fi WWW: http://cs.joensuu.fi/~pjuuti/
  "Deep inside ignorance prevails."
  --
• jPj E-Mail: pjuuti@cs.joensuu.fi WWW: http://cs.joensuu.fi/~pjuuti/
  "Deep inside ignorance prevails."