My Oracle Support Banner

XML Report Preview : Java.Sql.Sqlexception: No Corresponding Lob Data Found (Doc ID 418374.1)

Last updated on AUGUST 07, 2024

Applies to:

BI Publisher (formerly XML Publisher) - Version 5.6.2 to 5.6.3 [Release 5]
Information in this document applies to any platform.
FNDRSRUN.fmb version 11.5.154
 


Symptoms

One gets the following error when clicking on the Preview button of the FNDRSRUN forms for a XML
Publisher custom report:

java.sql.SQLException: No corresponding LOB data found : SELECT FILE_DATA,
DBMS_LOB.GETLENGTH(FILE_DATA), FILE_NAME, LAST_UPDATE_DATE FROM XDO_LOBS WHERE
LOB_TYPE = :1 AND APPLICATION_SHORT_NAME = :2 AND LOB_CODE = :3 AND LANGUAGE =
:4 AND TERRITORY ...........

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.