BI Publisher 11G: How to display a BLOB Image in an RTF Template.

Although the task seems relatively easy, the information available is too vague and you might find yourself struggling to understand what needs to be done, specially if you are just getting started with BI Publisher. In order to display a BLOB image in the report template RTF (using MS Word BI Publisher Plugin), follow the next steps:

  1. Insert the field as usual.blob field
  2. Double-click on the field and replace the code for something like:
  3. code

<fo:instream-foreign-object content-type=”image/jpg” height=”3.25 in” width=”2.5 in”><xsl:value-of select=”.//PASSPORT_PICTURE”/></fo:instream-foreign-object>

Please note that the xsl:value-of select=”.//PASSPORT_PICTURE” is using XPATH so .// stands because in my data model, the picture within a 2 levels nested collection.

That is all!

Leave a comment

Your email address will not be published.

Social Media

Stay up-to-date with our latest ADF and related technical posts via your favourite social network services.