Announcement

Collapse
No announcement yet.

How to show BLOB Image Dynamically in RTF report

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to show BLOB Image Dynamically in RTF report

    Hi, I am storing my image as BLOB in database, and had created 1 function to encode BLOB to CLOB in database.
    Then I create a report, and in my data template, I added below to return the base64 so I can show as image in my RTF

    ===================================
    select object_gid as object_gid
    , base64encode(qrcode_img) as IMAGE_FILE
    from QRCODE_TABLE1
    ====================================

    However, I am not returning any value in the XML for this <IMAGE_FILE> tag, so the image is not showing too.

    I am following this tutorial Oracle XML Publisher - Display BLOB Image Dynamically- https://www.youtube.com/watch?v=3qKOtgFPldQ
Working...
X