ColdFusion 2021 CF_SQL_CLOB
We have a table in an Oracle database with a data type CLOB. We use the CF_SQL_CLOB CFSQLTYPE in the database query but we get an Oracle error indicating that the data exceeds the 4000 character limit with the VARCHAR2 datatype. We tried using both the ColdFusion Oracle driver and the JDBC driver from Oracle's site. Both are throwing the same error (see below).
What is this CF_SQL_CLOB type? This site indicates that this is for CLOB or NCLOB data types.
https://cfdocs.org/cfsqltype-cheatsheet
Any suggestions would be greatly appreciated. Thank you.
Error:
OriginalSql = select 1 as test
from request_desc
where to_char(text) = ?
and requests_id = ?, Error Msg = ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4030, maximum: 4000)
This is the table definition:
COLUMN_NAME DATA_TYPE
-------------------- ------------------------------
REQUESTS_ID NUMBER
TEXT CLOB
AdChoices