BI Publisher Bursting Query Fails with the Error "ORA-01704: string literal too long" when Adding a Long HTML Code More than 4000 Characters (Doc ID 2883738.1)

Last updated on SEPTEMBER 01, 2022

Applies to:

Symptoms

When attempting to add HTML code in bursting query (e.g. HTML code has more than 4000 characters), the following error occurs in the Bursting definition page :

The issue can be reproduced at will with the following steps:

In the Bursting definition table, create a new bursting definition by specifying its name, type, data source, and other properties

1. On the component pane of the data model editor, click Bursting to create a SQL data set to create a bursting query.

2. On the Bursting definition table, click the Create new Bursting button.

3. Enter the following for this bursting definition:

   3.1. Name - Enter a name for the query, for example, Burst to File.

   3.2. Type - SQL Query is currently the only supported type

   3.3. Data Source - Select the data source that contains the delivery information

4. In the lower region, enter the following for this bursting definition:

   SQL Query — Enter the query to construct the delivery XML.

5. The error occurs when more than 4000 characters are identified.

Cause

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