Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Owarepl : Is this a bug or feature?
tkyte_at_us.oracle.com (Thomas Kyte) writes:
...
>Right now, it already does pass the query_string on through (owarepl does,
>OWA does not) when using GET but it also parses it out. Try ...
I have looked at the source of owarepl in more detail and have tried a few things but have not been able to change it so that it does not parse out the query_string.
I have written a function that examines the query_string and parses it. Is it possible to not feed any data to a procedure and only make the environment variables available to it?
If not then what is a good way to process say, shopping basket data? When you know the types of variables coming in, but not the number.
How would you change the following take_order procedure to handle this, keeping in mind that the number of variables can change?
dcd/owa/showenv?product1=pencil&qty1=20&product2=camera&qty2=1
create procedure take_order( product1 in varchar2, qty1 in varchar2 ) is begin
owa_util.print_cgi_env;
end;
/
I can also think of another example of dynamic forms. Forms with checkboxes. I have noticed that if a user does not select a checkbox, neither the variable nor the value is passed. Here is how I have been putting them in my forms.
<INPUT type="checkbox" NAME="checkbox1" value="1">
For now I am handling them in a rather ugly way. If there are more than a couple of checkboxes in a form, it gets super ugly. I am sure I am missing something very basic and would appreciate if you could point me in the right direction.
Thanks very much.
Atif Khan
aak2_at_ra.msstate.edu
Received on Fri Jun 27 1997 - 00:00:00 CDT