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 laterInformation 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 :
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 |