Re: OWS: passing LOTS of CGI parms

Mark,

OWS doesn't allow you to use records as parameter types. But it does allow you to use PL/SQL table as the parameter type.

If you name all of your HTML form elements the same name on the page1 , you should only have one parameter on page2. Take a look at owa_util.ident_array datatype.  

The bad part is that in this case you have to somehow encode what does each form element really mean.

For example,

<input type=hidden name=a value="1">
<input type=hidden name=b value="2">

will become:

<input type=hidden name=c value="a_1">
<input type=hidden name=c value="b_2">

and page2 will have to decode passed values.

Hope this helps,

Igor

Mark Aurit wrote:
>
> I have , at more than time in my OWS app, over 90 parameters to pass.
> Im doing them all by name, but its sooo ugly. Ive tried using a PLSQL
> RECORD with a test package below .. but page2 barfs. Ive tried every
> permutation I could think of.
> Any ideas greatly welcome!
> Mark
> auritma AT mail.northgrum.com
>
> CREATE OR REPLACE package test1 is
> type myrec is record
> (var1 varchar2(20),
> var2 varchar2(10));
> procedure page1;
> procedure page2 (myrec2 myrec);
> END;
> /
>
> CREATE OR REPLACE package body test1 is
> procedure page1 is
> myrec2 myrec;
> begin
> htp.formOpen(curl=>'testrec.page2',cmethod=>'GET');
> htp.formhidden('myrec2.var1','ford');
> htp.formhidden('myrec2.var2','gm');
> htp.formSubmit(cvalue=>'hit me');
> htp.formclose;
> end;
>

> /
Received on Wed Aug 19 1998 - 11:28:23 CDT