OK, as a last ditch resort, dedicate some other DB to storing your Client
variables, say SQL server. That should get around the problem.
At 09:17 AM 12/5/00 -0600, Shannon Hicks wrote:
>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
