modplsql array parameter limitation

From: Robert <rchin_at_panix.com>
Date: Wed, 15 Dec 2004 18:06:50 -0500
Message-ID: <cpqg1p$p3g$1@reader1.panix.com>

8.1.7.4 (Windows)
9.0.4.0.0 Oracle-HTTP-Server (Linux)

can you confirm that array param (pl/sql table) is limited to 2000 items. And if so, how would you deal with this limitation ?

thanks

functional test code below -- CREATE OR REPLACE PACKAGE rc_test IS PROCEDURE one ; PROCEDURE two(p_big_array IN owa_util.ident_arr) ; END rc_test;

CREATE OR REPLACE PACKAGE BODY rc_test IS

  PROCEDURE top
  IS
   l_str VARCHAR2(32000) ;
  BEGIN
   l_str := '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01

Transitional//EN">' || chr(10) ||


            '<html>' || chr(10) ||

            '<head>' || chr(10) ||

            '  <title>rc_test</title>' || chr(10) ||


            '</head><body>' ;

     htp.p(l_str);

  END ;
  PROCEDURE tail
  IS
   l_str VARCHAR2(32000) ;
  BEGIN
   l_str := '</body></html>' ;
     htp.p(l_str);
  END ;   PROCEDURE one
  IS
    p_big_array owa_util.ident_arr;
  BEGIN

     SELECT object_name BULK COLLECT INTO p_big_array
     FROM all_objects ;
     top;
     htp.p('<FORM name="frmExport" method="post" action="rc_test.two">');
     FOR i IN p_big_array.FIRST..2001 --<<-- ERROR IF > 2000
     LOOP
       htp.p('<INPUT TYPE="hidden" NAME="p_big_array" VALUE="' ||
             p_big_array(i) || '">');
     END LOOP;
     htp.p('<INPUT type="submit" value="Print Results">') ;
     htp.p('</FORM>') ;
     tail ;

END ; PROCEDURE two(p_big_array IN owa_util.ident_arr) IS
BEGIN

     top;
     FOR i IN p_big_array.FIRST..p_big_array.LAST
     LOOP
       htp.p(' Value: ' || p_big_array(i) || '">');
     END LOOP;
     tail ;

END ; END rc_test; Received on Wed Dec 15 2004 - 17:06:50 CST