Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CLOB Type not Supported - HELP

Hi,

I am connecting to an oracle DB using the OLE DB connect option.

In my preceding load and select statements I am trying to read in a CLOB type. i am getting an unknow type error. Any suggestions?

LOAD PROJECT As Project,
DESCRIPTION as Description //(TYPE CLOB)

SQL SELECT
DESCRIPTION,

FROM .....

PLEASE HELP.

1 Reply
biester
Specialist
Specialist

AFAIK you have to use ODBC when reading LOBs from Oracle, not OLEDB (at least I didn't succeed with OLEDB).

Rgds,
Joachim