APEX Interactive Report Gives ORA-6502 Error When Downloading More Than 26 Columns of Report Data (Doc ID 1551419.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.1.1 and later
Information in this document applies to any platform.

Goal

When running an APEX Interactive Report  the following error message is seen when try to download data in EXCEL format. If any combination of 26 columns is selected it is fine, the moment 27th column is added the following error occurs :

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