It appears that when you attempt to insert a string longer than 32K into a CLOB, and bind as string the server reports ORA-01461: can bind a LONG value only for insert into a LONG column I wrote a ...
When ingesting data from another source, if the source data is text over 4000 characters, there is a significant performance penalty when inserting to the CLOB/NCLOB type in Oracle.
Oracle's namesake database management system has a data type called a CLOB, or Character Large OBject. Though the standard character data type, called CHAR, has a size limit of 2,000 characters, you ...