The direct drivers *can* handle CLOBS... but Allaire's client variable
engine passes the client variable as a string literal, which, according to
the SQL 97 standard, can't be over 2k.
Oracle basically said it's Allaire's problem, and I'm waiting for Allaire to
get back to us.
Shan
Shannon Hicks
Senior Developer
[EMAIL PROTECTED]
http://www.duodesign.com <http://www.duodesign.com>
duoDesign eBusiness Accelerator
1007 Church Street, Suite 510
Evanston IL 60201
847-491-3211 direct
847-491-3000 main
847-491-3100 fax
-----Original Message-----
From: Douglas Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 04, 2000 12:54 PM
To: Fusebox
Subject: Oracle CLOBS
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
