Yes, you don't HAVE to use the Client DB structure that was created for
you.....
As long as the Client tables have the correct field names, and basic type,
you can tweak with them....
At 12:53 PM 12/4/00 -0800, Dan Haley wrote:
>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
