How to display BLOB image in XML Publisher - JointLantic - Program Language about Peoplesoft, Peoplecode, People Tool , SQL, Application Engine (AE), XML / BI Publisher

How to display BLOB image in XML BI Publisher

BI Publisher – Retrieving images from BLOB data in RFT template

If results XML contains image data that had been stored as a BLOB in the database, then use the following syntax in a form field inserted in the template where you want the image to render at runtime:

Syntax:

&lt;fo:instream-foreign-object content-type="<span class="italic">image/jpg</span>"&gt;
&lt;xsl:value-of select=".//<span class="italic">IMAGE_ELEMENT</span>"/&gt;
&lt;/fo:instream-foreign-object&gt;

<fo:instream-foreign-object content-type="<span class="italic">image/jpg</span>">

<xsl:value-of select=".//<span class="italic">IMAGE_ELEMENT</span>"/>

</fo:instream-foreign-object>

Example:

<fo:instream-foreign-object content-type=”image/jpg”>
<xsl:value-of select=”.//B.SIGN_TT_IMAGE”/>
</fo:instream-foreign-object>

display BLOB image in XML BI Publisher

Reference 1 :https://www.youtube.com/watch?v=5lUBMxx0pd0
Reference 2 :https://docs.oracle.com/middleware/11119/bip/BIPRD/create_rtf_tmpl.htm#iamge_and_chart