Problem when reading from Oracle where a column i a CLOB

janus2021 — Thu, 22 May 2025 06:01:52 GMT

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?

BR
Janus

topic Problem when reading from Oracle where a column i a CLOB in App Development

Problem when reading from Oracle where a column i a CLOB