Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QS_kdefok
Partner - Contributor III
Partner - Contributor III

Oracle SQL - RAW format - system.byte[]

Hello,

I started a new project in my Desktop version, trying to play with datas from an Oracle database with one SQL table A.

I set up an Oracle connector but I have an issue : the primary key "ID" is formatted in the RAW format. 
When I load the table, the datas are all read as: system.byte[].

It seems that the RAW format is not supported for the Oracle Database from what I read below:
https://help.qlik.com/en-US/compose-datawarehouses/November2020/Content/ComposeForDataWarehouses/Mai...

Do you have a workaound? 

I tried to use the SQL function UTL_RAW.CAST_TO_VARCHAR2 in the load script to convert the RAW data type to  VARCHAR2 but it was not better.

FYI, I don't have the hand on the DB to change the datatype, I have just access in read only.

Many thanks for your support !

Labels (2)
0 Replies