Re: mod_plsql question re max length of POSTed data
Date: Fri, 16 May 2008 05:33:45 -0700 (PDT)
On May 16, 1:19 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> On 16 Mai, 13:50, jeremy <jeremy0..._at_gmail.com> wrote:
> > Hi folks
> > With 9i on Solaris we seem to be able to post large values (>32k) via
> > mod_plsql where in 10g it appears there is a restriction.
> > The doc for 10g (9.0.4 of AS)
> > "mod_plsql limits the size of a single parameter that can be passed to
> > a procedure to 32000 bytes."
> > This is a barrier to migrating to 10g - don't understand why the
> > limitation doesn't appear to exist in 9i?
> > --
> > jeremy
> Don't your link to documetation implies the limitation *does* appear
> to exist in 9i?
Well the documentation states 10g (AS 9.0.4) so not entirely sure... but we are experiencing different behaviour between three environments running same application code:
Solaris 9iR2 - 90,000 bytes OK
RHEL 10gR2 - 90,000 bytes ERROR
Windows2000 - 90,000 bytes OK
> IIRC this limitation was always in place, regardless
> of Oracle version. There can be made different workarounds ( one that
> posted data in a number of 32k chunks and submit them all
> individually, but such workarounds are mostly equally well applicable
> for 9i and 10g.
I'd like to understand why the difference in behaviour but could you indicate where such workarounds are documented?
-- jeremyReceived on Fri May 16 2008 - 07:33:45 CDT