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
