Allaire suggested that too... no luck. Different problem there.
Shan
-----Original Message-----
From: Douglas Smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 04, 2000 6:56 PM
To: Fusebox
Subject: RE: Oracle CLOBS
What if you used the Oracle direct drivers for your regular Oracle DB work,
and the ODBC drivers to get to your Client variables table? Will that help?
At 03:18 PM 12/4/00 -0600, Shannon Hicks wrote:
>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
