I have a query for a Interactive Report that runs > 800 lines, with about 23,000 characters.
It access four tables, with identical SELECT statements and UNION ALL to put them together. Each of of the SELECTs has > 150 columns.
If I knock down the size to three tables, roughly 600 lines, it works fine.
When the full query is saved into the view source, when I run the page, it fails, with error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" in the space under the search bar, where you would see "No data found" or the actual interactive report rows and columns.
The Debug page shows nothing obvious, no lines that include 'error'.
Is this error because the query is too big when processed at run time, but not at compile time when you save the page source?