mod_plsql question re max length of POSTed data
jeremy
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)
http://download-west.oracle.com/docs/cd/B10464_05/web.904/b10357/concept.htm#1006241
"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
Maxim Demenko
> 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? IIRC this limitation was always in place, regardless
of Oracle version. There can be made different workarounds ( one that
i am aware of - with javascript and AJAX calls) which would split
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.
Best regards
Maxim
jeremy
> 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?
>
A little more information on this - we actually found that on 10gR2 on
Windows2000 we can easily POST 90,000 chars BUT 10gR2 on Linux (RHEL4)
the limit is encountered.
Anyone any thoughts on this?
--
jeremy
jeremy
> On 16 Mai, 13:50, jeremy <jeremy0...@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)
>
> >http://download-west.oracle.com/docs/cd/B10464_05/web.904/b10357/conc...
>
> > "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
> i am aware of - with javascript and AJAX calls) which would split
> 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?
Many thanks
--
jeremy
Matthias Hoys
"jeremy" <jerem...@gmail.com> wrote in message
news:2335ae34-59c0-4baa...@f36g2000hsa.googlegroups.com...
Strange to believe that the limit would be operating system specific. Do you
have the same modplsql configuration and patches on both systems ?
Maxim Demenko
Have a look at this example
http://www.oracle.com/technology/products/database/application_express/packaged_apps/packaged_apps.html#LARGE
Granted, it is ApEx example, but the same method could be applied to any
mod_plsql application, just a little bit more code to write ;-)
Best regards
Maxim
jeremy
says...
>
> "jeremy" <jerem...@gmail.com> wrote in message
> news:2335ae34-59c0-4baa...@f36g2000hsa.googlegroups.com...
> >
> > A little more information on this - we actually found that on 10gR2 on
> > Windows2000 we can easily POST 90,000 chars BUT 10gR2 on Linux (RHEL4)
> > the limit is encountered.
> >
> > Anyone any thoughts on this?
>
> Strange to believe that the limit would be operating system specific. Do you
> have the same modplsql configuration and patches on both systems ?
Did some testing - was relying on something I had been told - turns out
the limit of ~32k *is* in 9i as well BUT Oracle simply didn't raise any
exception - but the data received at the other end was not the full 90k.
--
jeremy
jeremy
> Have a look at this example
> http://www.oracle.com/technology/products/database/application_express/packaged_apps/packaged_apps.html#LARGE
> Granted, it is ApEx example, but the same method could be applied to any
> mod_plsql application, just a little bit more code to write ;-)
>
>
Thanks Maxim.
--
jeremy