My Oracle Support Banner

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:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

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 :

"ORA-01704: string literal too long".


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

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.