Re: Does anybody know what is the limit on argument size passed to JDBC CallableStatement.setObject()?

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Does anybody know what is the limit on argument size passed to JDBC CallableStatement.setObject()?

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Wed, 15 Feb 2006 14:38:19 -0500
Message-ID: <367369f10602151138n68b3851bp60d436609b7591bc@mail.gmail.com>

Yes, thanks, we have information limit is 64k.

Regards, Ranko.

On 2/15/06, Peter Sylvester <peters_at_mitre.org> wrote:
>
> I don't have the actual answer to your question, but I'd suggest trying
> out the latest JDBC driver, from 10.2, even if you are connecting to 9.X.
> Supposedly a lot of stuff that was being done using PL/SQL under the
> hood got reimplemented in more native code. PL/SQL seems to like things
> to be under 32K or so, IIRC.
>
> --Peter
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 15 2006 - 13:38:19 CST