FROM THE BLOG

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.
2. Double-click on the field and replace the code for something like:
3. 

<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!