How to display an images from a value field from a DB Oracle

[t_donnet]

The difficulty is that the image (jpg) is stored as a value in an Oracle DB.

The image value is in hexadecimal (Start with FFD8FFE0…).

I cannot found a way to display the image on Qlik Sense.

How to display the image from the field value ?

[Or]

Have a look at this:

https://community.qlik.com/t5/Official-Support-Articles/How-to-read-images-from-a-database-and-displ...

Specifically with Oracle, there should be a RawToHex function if the hex can't be displayed as an image, I think. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/HEXTORAW.html

[t_donnet]

This article treats only on MSQL. 

With the oracle documentation, I manage to have an error message:

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-00932: inconsistent datatypes: expected - got BLOB 

[Or]

Sounds like your data might already be in blob format, rather than hex? I haven't done this in many years but I did get Oracle BLOBs to display in Qlik in the distant past, iirc. It's been over a decade and in QV rather than QS so I don't have any actual code to look at, unfortunately.