KUP-04026: field too long for datatype for CLOB column
394430Mar 10 2006 — edited Mar 10 2006Hello
when I try to select from an external table that has a CLOB column a lot of rows are rejected with the error
KUP-04026: field too long for datatype
The field that is too long is supposedly the CLOB column. However I know the data is not too long for a CLOB and indeed when I change the column to VARCHAR2(4000) the majority of the rows are no longer rejected as the size is less than 4000. Can anyone tell me what the problem is? thanks.