Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help! ORA-01036 / Oracle 9ir2 / Oracle HTTP server / mod_plsql

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

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 17 Nov 2004 20:03:02 +0100
Message-ID: <cndiug$moj$2@news4.zwoll1.ov.home.nl>


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!

-- 

Regards,
Frank van Bortel
Received on Wed Nov 17 2004 - 13:03:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US