Problem when reading from Oracle where a column i a CLOB
Hi.
I try to load data from Oracle and 1 column i CLOB. It contains up to 5000 characters. Using TEXT only givs me about 4000 of 5000 characters in the column. So i end up missing som data. If i read same data from a Excel-fil, it no problem to get all 5000 characters.
{ My Load:
LOAD FK_numbers, TEXT(CLOB_COLUMN) AS CLOB_COLUMN, Term_INT;
[CLOB_C]: SELECT "FK_numbers", "CLOB_COLUMN", "Term_INT" FROM "some_tabel_in_Oracle"; }
Any one that has a solution to my problem, how to read a CLOB column from Oracle and retrive all data?