Re: OWS: passing LOTS of CGI parms

From: <oracle_at_nettwerk.com>
Date: Wed, 19 Aug 1998 12:02:32 -0700
Message-ID: <35DB2148.2847FC88@nettwerk.com>

Actually I just define a new type.

For instance, here is a test package and procedure showing how I've used it:

create or replace
package test_array is

	type varchar_array is table of varchar2(30) index by binary_integer;
	null_varchar varchar_array;
	procedure test (p_array in varchar_array default null_varchar);

end test_array;
/

create or replace
package body test_array is

	procedure test (p_array in varchar_array default null_varchar) is
	begin
		for x in 1 .. 10000 loop
			begin
				array_value := p_array(x);
			exception
				when others then exit;
			end;
		end loop;
	end;

end;
/

The <input type=hidden name=p_array> is used to pass these values into the package from html forms.

...jeff Received on Wed Aug 19 1998 - 14:02:32 CDT