Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

KUP-04026: field too long for datatype for CLOB column

394430Mar 10 2006 — edited Mar 10 2006
Hello

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2006
Added on Mar 10 2006
6 comments
7,460 views