BI Publisher – How to insert a CLOB data from a table into rtf Template- Inserting Images into rtf from tables

Often there are requirements of inserting Image files saved as CLOB data in the table, to be inserted into rtf Templates.

For doing this the data has to be selected in the Data Model.

Following tag has to be used.

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

Where IMAGE_FILE is the name of the CLOB column