topic Re: How to display an images from a value field from a DB Oracle in App Development

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

t_donnet — Wed, 01 May 2024 11:47:13 GMT

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 ?

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

Or — Wed, 01 May 2024 12:09:42 GMT

Have a look at this:

https://community.qlik.com/t5/Official-Support-Articles/How-to-read-images-from-a-database-and-display-in-Qlik-Sense-and/ta-p/1711247

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

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

t_donnet — Wed, 01 May 2024 14:49:56 GMT

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

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

Or — Thu, 02 May 2024 07:28:24 GMT

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.