Sorry, I can't help you much, I spent about a month testing the Oracle 9i driver with CFMX and ran into alot of random issues like the one you've mentioned. However I'm not saying the DataDirect driver is all that, because imho it is shit as well, but when it comes to CF/Oracle integration there is more support and help with the supplied driver.
Are both datasources running in the same instance of CF? I'm just wondering if reinstalling the drivers might solve the problem, however if its the same instance you may want to start examining the differences in the schema. This is a complete stab in the dark, but sometimes this helps if there is some weird data corruption error... wrap the column name in COMPOSE() to covert it to unicode. Ive had instances where the clob could be pulled in SQL*Plus and TOAD, but would lock up the thread if pulled through the DataDirect drivers. COMPOSE() seemed to do something to the data when it converted it to unicode that made CF happy. Again, it's most likely the crappy dataDirect drivers. -Adam On Tue, 04 Jan 2005 13:19:26 -0400, Doug Bezona <[EMAIL PROTECTED]> wrote: > >Are you using the supplied dataDirect thin driver? If so have you run > >the 6.1 updater for the latest version? > > No, the Oracle supplied thin driver. > > >How are you pulling the CLOBs? Are you using cfstoredproc or cfquery? > > cfquery > > >Are clobs enabled for the datasource via the CF Admin? > > yes > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
