Oracle Rest + Oracle Apex 5, not displaying images on reports.

Igor Sala

Hello folks!

I'm using Oracle Apex + Oracle Rest Data Service and trying to display employee's photo in a report, but an error occurred:

note: Directly on Apex, without pass trough the Rest, works fine. 

500 Internal Server Error

• An unexpected error with the following message occurred: .jpg; charset=utf-8

The query:

SELECT dbms_lob.getlength(photo) Photo

   FROM fotos

And Oracle Apex is using apex_util.get_blob to try display image.

Thanks for helping!

Igor Sala

Hey folks, I did it!

My table Photos contains the following columns: Code number(6), Filename varchar2(100), Type varchar2(20), Photo Blob, Charset varchar2(20).

Directly on Apex, the column Type was '.jpg' and works fine.

When I use ORDS, Type column must be 'image/jpg', then works.

Thank you.

Bharat G

Error message looks like Charset is missing. Do you have Charset field in the table and attached in the APEX Blob Attributes to its corresponding field ?

Regards,

Bharat

Igor Sala

Yes, I did it, but no success. As I said before, the curious thing is that works directly on Apex, the image displays, but only when I'm not accessing by Oracle Rest.

Thank you for your attention, Bharat.

Igor Sala

Hey folks, I did it!

My table Photos contains the following columns: Code number(6), Filename varchar2(100), Type varchar2(20), Photo Blob, Charset varchar2(20).

Directly on Apex, the column Type was '.jpg' and works fine.

When I use ORDS, Type column must be 'image/jpg', then works.

Thank you.