> I have a situation where well-formed INSERT or UPDATE > pass-thru queries fail through the native Oracle driver, but > executes successfully in Toad or SQL*Plus: > > [Macromedia][Oracle JDBC Driver][Oracle]ORA-01704: string > literal too long > > I'm running CFMX 6.1 and Oracle 10G. I've verified this in > three Oracle/CF instances. There are no extended character > sets (all one byte characters.) Using default Oracle 10G > character set. > > I am aware that this was an issue with versions of CF prior > to version 5.0 - all the posts out there simply seem to > interate this fact (but it doesn't help in solving the > problem.) Has there anybody out there dealt with this > problem, and found a fix (outside of using CLOBS?)
I have no idea how to fix your problem, but I thought these questions might be helpful. Have you downloaded the latest DataDirect JDBC drivers from the CF hotfix list? Are you using CFQUERYPARAM? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275574 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
