ColdFusion errors when inserting, updating or selecting Oracle 12c Varchar2 columns that are over 4000 characters| View in Tracker
Failure Type: Incorrectly functioning
Found In Build/Fixed In Build: CF 11 and 2016 / 312339
Priority/Frequency: Normal / All users will encounter
Locale/System: ALL / Windows 7 64-bit
Vote Count: 1
Problem Description: Oracle 12c can now store over 32k of data in a Varchar2 columns instead of the previous limitation of 4000 and we are trying to utilize that option but are receiving ColdFusion errors when trying to do so. Steps to Reproduce: Run SQL statement with cfparam inserting, updating or inserting data over 4000 bytes into a column that is configured to accept over 4000 in the db. Actual Result: Error Code: 24920 Message: [Macromedia][Oracle JDBC Driver][Oracle]ORA-24920: column size too large for client Expected Result: A successful sql statement Any Workarounds: Taking the cfparam off the insert works but that isn't an option for us. The update and select fails with the above error code regardless.