> I've encountered similar behaviour with Oracle ODBC drivers on Linux > connecting to Oracle 8 on HP-UX, had to run a separate insert/update on the > CLOB column and then update the rest of the columns. I was able to retrieve > the data once inserted tho. Never got a real fix for it, just had to go > with the workaround.
Yeah, having to do an insert followed by an update is no biggie, but I've hit a snag -- the CLOB update works when the amount of data is comparatively small. When there's a large amount of data (haven't found the exact boundary, but 112Kb failed), the update (interestingly) doesn't throw an error, but there's no data in the CLOB field. Which kindof defeats the purpose of using a CLOB. Poops. > There is a dbms_lob package for PL/SQL which can be used to handle LOBs, > but I've never seen it used with a reference id like that returned by your > drivers - there are functions which accept the column name as arguments. Well, the other developer here has very kindly just written a function that takes chunks of data and writes them to an in-memory table, and then converts those chunks back into a CLOB that's stored in the reports table. He's currently writing a function to do the reverse, which I'll concatenate back into a string in CF. It's a crazy plan, but... > Looks like you'll be best off just going with the pure java JDBC drivers. In this page http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/dataso15.htm someone from MM says "When Oracle implements CLOBs fully in their Thin driver, users will be able to INSERT/UPDATE clobs with CFMX with the thin driver and the cheaper version of CFMX. The release note for 52292 (known issues) states: "The Oracle Thin Client will not work with CLOBS/BLOBS on CFMX. You need to use the Data Direct Oracle JDBC driver that ships with CFMX Enterprise to work with CLOBs/BLOBs on Oracle." This really confuses the issue and implies you need Enterprise when this was not the intent of the note. It should have been re-worded to say "Oracle doesn't implement full CLOB support in their Type 4 Thin driver as of the 6.1 release." So, is it correct that we either - buy some third party JDBC drivers and cross our fingers (the article motions one at $249) - buy CFMX Enterprise for its Type IV drivers, or - wait for Oracle to build CLOB support into the thin client? > BTW, why the thin driver rather than the OCI driver? Um.... partly because I don't really know what it is (so far, anything other than ODBC is black magic to me), and partly because this document http://www.macromedia.com/support/coldfusion/ts/documents/oracle_oci_sup port.htm says "The following database operations are not supported in ColdFusion MX with the Oracle OCI JDBC driver. Cannot SELECT/UPDATE/INSERT/DELETE columns with the data type BLOB. Cannot SELECT/UPDATE/INSERT/DELETE columns with the data type CLOB. Cannot use Oracle Ref Cursors." which (if I understand correctly) kinda puts the kybosh on it. Thanks for your responses so far, btw. -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> Fairbanks uses anti-spam filtering. If you sent an e-mail and expected to receive a response but didn't, please call -- it may be that your e-mail didn't make it to the intended mailbox. ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
