How To Generate Data More Than 65536 Rows By 80 Characters (Doc ID 889482.1)

Last updated on DECEMBER 12, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 10.1.3.3.2 to 10.1.3.4.1 [Release 10.1]
Information in this document applies to any platform.

Goal

Created a BIP report with a query including 29 columns. Querying all records will fetch 9300 records. Also, created an Excel template with Excel analyzer and assigned it as template to BIP report.

If I limit the query like ".. and rownum<100", the report that generated XLIFF data more than 65536 rows by 80 characters?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms