OWS: passing LOTS of CGI parms

From: Mark Aurit <auritma_at_mail.northgrum.com>
Date: Tue, 18 Aug 1998 15:33:26 GMT
Message-ID: <35d99b59.58269727@news.northgrum.com>

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;

       procedure page2 (myrec2 myrec) is
       begin
              htp.p(myrec2.var1);
              htp.br;
              htp.p(myrec2.var2);
              htp.br;
       end;

END;
/
Received on Tue Aug 18 1998 - 10:33:26 CDT