All: 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?) Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
