Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
janus2021
Creator
Creator

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?

BR
Janus

 

Labels (2)
0 Replies