At 11:26 AM 12/4/00 -0600, Shannon Hicks wrote:
>OT - Did you know that if you're using Oracle 8i, Cold Fusion can only
>handle 2k of client variables (with the native drivers)?
>
>Use the ODBC drivers you say? Well, then there's no native CLOB support
>(4.5.1 SP2)
Hi Shannon,
While I don't have any actual experience with the direct drivers, from what
other's have told me, that is not correct. You should be able to handle
VERY high chunk sizes with the direct drivers. There is probably some
setting or parameter you need to tweak with.
However, if you need an ODBC workaround, I can dig up a solution that we
implemented.
Using ODBC, we were able to pass-through very large chunk sizes (over 64K)
from form text area fields to Oracle CLOBS using IE. The solution involves
looping over the incoming text with multiple updates on the CLOB field,
using a stored procedure (a regular update query did not seem to work with
CLOBS)
Netscape 4 had a built-in 32 K limitation at that time.
- Douglas
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
