Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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