My Oracle Support Banner

XML OUTPUT FROM REPORTS WITH BLOB COLUMN IS NOT WORKING (Doc ID 435404.1)

Last updated on APRIL 13, 2024

Applies to:

BI Publisher (formerly XML Publisher) - Version 5.6.2 and later
Information in this document applies to any platform.
Business Intelligence Publisher, BI Publisher

Symptoms

The feature which is listed in the About Publisher 5.6.2 document (<Note:367394.1>) is not working.
--------------------------------------------------------------------------
New Features
Data Engine New Features
Support for retrieving BLOB images and CLOB column contents
The data engine now supports queries to retrieve BLOB images stored in the
Oracle database. All image types supported by the RTF template are supported by
the data engine. The data engine returns the BLOB as 64-bit encoding in the
results XML.

You can also retrieve CLOB column contents. Whatever is stored in the CLOB will
be returned in the query results. For example, XML stored as CLOB in the
database can be returned as XML within the data engine results.


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.