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

  • From: Ranko Mosic <ranko.mosic@xxxxxxxxx>
  • To: peters@xxxxxxxxx
  • Date: Wed, 15 Feb 2006 14:38:19 -0500

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

Regards, Ranko.


On 2/15/06, Peter Sylvester <peters@xxxxxxxxx> 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
> --
> //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@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html

Other related posts: