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

In article <cndiug$moj$2_at_news4.zwoll1.ov.home.nl>, Frank van Bortel says...
> Jeremy wrote:
>
> > 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?
> >
>
> Using UTF, by any chance? 1333 chars <> 1333 byte!
>

Actually solved this problem by defining proper defaults for all of the arrays.

cheers

-- 

jeremy