Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

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

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

From: Peter Sylvester <peters_at_mitre.org>
Date: Wed, 15 Feb 2006 12:18:50 -0500
Message-ID: <43F3627A.9090807@mitre.org>

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 Received on Wed Feb 15 2006 - 11:18:50 CST

This message: [ Message body ]
Next message: Ray Stell: "Re: Linux multipathing for 10g DB on SAN storage"
Previous message: Luca Canali: "Linux multipathing for 10g DB on SAN storage"
Maybe in reply to: Ranko Mosic: "Does anybody know what is the limit on argument size passed to JDBC CallableStatement.setObject()?"
Next in thread: Ranko Mosic: "Re: Does anybody know what is the limit on argument size passed to JDBC CallableStatement.setObject()?"
Reply: Ranko Mosic: "Re: Does anybody know what is the limit on argument size passed to JDBC CallableStatement.setObject()?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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