The CF Enterprise DataDirect Oracle driver supports CLOBs and BLOBs of very large sizes, as long as the datasource is set up correctly for CLOB and BLOB retreival.
The thin driver has issues with cfstoredproc, which are not present in the DataDirect driver. On 2/14/07, Eric Roberts <[EMAIL PROTECTED]> wrote: > Yes...you are going to need the "thin driver" for this if you are doing > anything with clobs. Do a search on this...i ran across a CFDJ article on > it today that explains it all. The problem is with the native drivers, > clobs get limited to 4k characters...a bit shy of the 4 GB limit promised by > oracle. You also have to cfqueryparam with type cf_sql_clob or you will > have issues with the clob data getting corrupted. I was just dealing with > this at work today ;-) -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269769 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
