BI Publisher (MOSC)

MOSC Banner

How to extract BLOB image in data template

edited Nov 20, 2018 11:25AM in BI Publisher (MOSC) 7 commentsAnswered ✓

I am trying to extract a blob image for insert into a BI Publisher report in EBS 12.1.3.  Below is my data template which appears to work, but I can not get the blob image to render; the Q_ATTCHMT section is the query from FND_LOBS.  Is this the correct way to extract the blob image from the database?

<?xml version="1.0" encoding="utf-8"?>

<dataTemplate name="PRODCARD" description="Production Card Data" Version="1.0" dataSourceRef="TESTNEW">

  <properties>

    <property name="include_parameters" value="true" />

    <property name="debug_mode" value="on" />

  </properties>

  <parameters>

    <parameter name="JOB_FROM" dataType="character" />

    <parameter name="ORG_ID" dataType="number" />

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center