True, but there is a max of 2000 characters because of the string literal
limitation. Even if you change the field type (as Allaire suggested to us)
to a CLOB or anything longer than 2k, it still will not work.
Shan
-----Original Message-----
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 04, 2000 2:53 PM
To: Fusebox
Subject: RE: Oracle CLOBS
The problem isn't with the ODBC or native drivers, it is with CF's
implementation of the client variables. The default tables created for
client variables use a VARCHAR2 field with the maximum length of 2000 (in
Oracle at least). Thinking while I'm typing - I suppose you could just
change the field type in the database . . . hmmmm . . . may have to give
client variables another look . . . ;)
Dan
-----Original Message-----
From: Douglas Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 04, 2000 10:54 AM
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
