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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2006

Added on Mar 10 2006

6 comments

7,462 views