topic Qlik Sense May 2022 is not supporting CLOB Data type from Oracle Source in Connectivity & Data Prep

Qlik Sense May 2022 is not supporting CLOB Data type from Oracle Source

ammaressaa — Fri, 15 Jul 2022 06:31:56 GMT

I have an Oracle Data Connection in Qlik Sense May 2022 version. There are tables in the schemas which have fields with CLOB data type. Whenever I try to extract the data from the particular table with fields of CLOB data type, it shows the error "ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00903: invalid table name".

With Qlik Sense November 2021 version, it was working perfectly. This means that newer Qlik Sense versions are not supporting CLOB data type.

Does anyone have an alternate solution since the field has more than 4000 characters.

Re: Qlik Sense May 2022 is not supporting CLOB Data type from Oracle Source

petergassert — Tue, 26 Jul 2022 08:02:23 GMT

Hi Ammaressaa,
had the same Problem and i was able to fix this with changing my sql statement by changing the clob fields to varchar with following function CAST("Fieldname" AS VARCHAR2(3999)) as "Fieldname".

Hoe this helps on your side as well.
Best regards,
Peter

Re: Qlik Sense May 2022 is not supporting CLOB Data type from Oracle Source

Alex20 — Mon, 10 Oct 2022 09:16:05 GMT

Thank you very much, we also encountered this issue after upgrading, and the data fields did not match other normal tables