tracker issue : CF-4198861

select a category, or use search below
(searches all categories and all time range)

ColdFusion errors when inserting, updating or selecting Oracle 12c Varchar2 columns that are over 4000 characters

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Patrick Mackay / Patrick Mackay ()

Created: 06/15/2017

Components: Database, Oracle

Versions: 2016

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.



This is marked as third party. That is not correct unles the 3rd party is the driver. The error is either in CF or the driver, not Oracle. If you run a merge statement with a clob field using <cfqueryparam value="#textLargerThan4000#" cfsqltype="CF_SQL_CLOB" >, you will get this error. If you look at the params listed, cfqueryparam is incorrectly listing this param as a string ( (param 2) = [type='IN', class='java.lang.String', ). if you put the same variable through an insert statement, the param is listed as a clob. CF is not handling the variable correctly when running the merge statement. There are other cases too where it treats clobs as strings.
Comment by Matthew H.
27274 | April 03, 2018 02:31:46 PM GMT