SOLUTION

Installation and Configuration

 

Installing BLOB Destination

Copy the file BLOBDestination11g.jar into $ORACLE_HOME/reports/jlib folder.

A new jar file is required for the BLOBDestination in Reports 11g. This new jar file (BLOBDestination11g.jar) can be downloaded here

Deploying the new destination class

You need to make the BLOB destination jar file (BLOBDestination.jar) available to Oracle Reports via the classpath.

This procedure depends on whether you are using the in-process Reports Server or a standalone Reports Server. 
If you are using the in-process Reports Server, you need to modify the classpath for the WLS_REPORTS managed server.
The reason being that the in-process server inherits the classpath from its WLS_REPORTS instance.

If you are using the in-process reports server:

Edit the file setDomainEnv.sh (UNIX/Linux) / setDomainEnv.cmd (Windows) .
This file is in the directory $DOMAIN_HOME/bin.
Locate the lines :

On UNIX/Linux 

if [ "${SERVER_NAME}" = "WLS_REPORTS" ] ; then
POST_CLASSPATH=" ... :${CLASSPATHSEP}${POST_CLASSPATH}"
export POST_CLASSPATH
fi

On Windows :

if "%SERVER_NAME%"=="WLS_REPORTS" (
set POST_CLASSPATH= ... ;%POST_CLASSPATH%
)

Add BLOBDestination11g.jar in POST_CLASSPATH

Example on Windows :

if "%SERVER_NAME%"=="WLS_REPORTS" (
set POST_CLASSPATH= ... ;c:\oracle\fmw11g\oracle_pfrd\reports\jlib\BLOBDestination11g.jar;%POST_CLASSPATH%
)

Restart the managed server WLS_REPORTS from the Enterprise Manager or from the WLS console.

If you are using a standalone reports server:

Add the following entry to the REPORTS_CLASSPATH environment variable: 
$ORACLE_HOME/reports/jlib/BLOBDestination11g.jar

On Windows, use the registry to specify the value. On Unix/Linux, set the environment variable in reports.sh.

 

Register the new destination with the Oracle Reports Services

To register the new destination with the Reports Server, you need to add the new destination in the Reports Server configuration file.

To create this new destination using the "Oracle Enterprise Manager" Web Site :

Oracle Fusion Middleware Publishing Reports to the Web with Oracle Reports Services
11g Release 1 (11.1.1)
Part Number B32121-03 
7.13 Registering Pluggable Destinations with Reports Server

Name: BLOBDestination

Class: oracle.reports.plugin.destination.blob.BLOBDestination

Example :



If really needed, you can modify the files rwserver.conf manually.

Beginning in Oracle Reports 11g Release 1 (11.1.1), it is recommended that configuration should be done only through Oracle Enterprise Manager.

If you are using the in-process reports server:
The configuration file is in the directory : 
$DOMAIN_HOME/config/fmwconfig/servers/<WLS_SERVER_NAME>/applications/reports_<version>/configuration . 

If you are using a standalone reports server:
The configuration file is in the directory :
$ORACLE_INSTANCE/config/ReportsServerComponent/<Reports Server Name> . 

Specifically, add the following entry:

<destination destype="BLOBDestination" class="oracle.reports.plugin.destination.blob.BLOBDestination">
</destination>

Restart the Reports Server for your changes to take effect.

 

Caution
This sample code is provided for educational purposes only and not supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.
Please note also that there is no BLOBDestination.jar file in the Oracle Forms and Reports installation itself, also not in the 12c installation.