Help! ORA-01036 / Oracle 9ir2 / Oracle HTTP server / mod_plsql

Using mod_plsql in a 9ias / 9iR2 environment on Solaris 9

Packaged procedure has folliwng args:

procedure freedb

    (p_web_site_id              	in      number,
     p_candidate_id             	in      number default null,
     p_completed_flag	    	        in 	varchar2 default null,
     p_section_id               	in      number,
     p_next_section_id          	in      number default null,
     p_form_id                  	in      number default null,
     p_web_page_id              	in      number default null,
     p_sequential               	in      varchar2 default 'N',
     p_ccp_path				in	varchar2 default null,
     p_id1                      	in      number default null,
     p_id2                      	in      number default null,
     p_id3                      	in      number default null,
     p_id4                      	in      number default null,


     ..

     ..

     p_id99                     	in      number default null,
     p_id100                    	in      number default null,
     p_1                        	in      chararray,
     p_2                        	in      chararray,
     p_3                        	in      chararray,
     p_4                        	in      chararray,


     ..

     ..

     p_99                       	in      chararray,
     p_100                      	in      chararray);

The dots you'll have realised just to reomve the entiores 5-98 incl.

The tytpe chararray is defined as :

type chararray is table of varchar2(2000) index by binary_integer;

This procedure sometime seems to generate an Internal Server Error when called by an HTML form (it is the target of a FORM with POST method).

From the above package spec, you'll probably have already worked out that it is a procedure that can take its input of up to 100 fields. This works fine usually but sometimes it throws the above error. The example form I am working from has only 1 field defined that will be posted to this form. If the field contains 1330 chars, all is OK. If 1340, 'internal server error'.

So....any ideas what might cause this?

-- 

jeremy