This is a known bug and I believe it is a driver issue. In the meantime, I think you can get it to work by using the OCI drivers.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Stephen > Sent: Friday, October 08, 2004 5:10 PM > To: [EMAIL PROTECTED] > Subject: [CFCDev] DAO update problem > > I hope this isn't to OT but I have a DAO cfc that is trying to update a > CLOB field in an Oracle 9i database. Everything works fine until the > size of the text to put in the field is larger than 4000 characters. Is > there some limitation in MX that would prevent me updating a CLOB with > text longer than 4000 characters. From what I can tell, the CLOB field > should be able to handle a much larger chunk of text than that. Are > their certain drivers that should be used to do this? I'm currently > using the Oracle 9.2 jdbc drivers available on Oracle's website and > using a connections string of the form: jdbc:oracle:oci:@SID > > Any help would be greatly appreciated. > > Stephen > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at www.mail- > archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
