Oracle SQL - RAW format - system.byte[]

QS_kdefok — Tue, 28 Dec 2021 20:18:14 GMT

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/Main/Data%20Source%20Connections/non_supported_data_types_oracle.htm

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 !

topic Oracle SQL - RAW format - system.byte[] in Connectivity & Data Prep

Oracle SQL - RAW format - system.byte[]