I have 2 interactive reports that display on a page, a report that shows the data of forms submitted, and a file report that shows the files inserted. The main report has 9 columns, the majority being VARCHAR2(4000). The longest value we have in there though is 1110 characters. But we keep getting the ORA-06502: PL/SQL Numeric or Value Error: Character string too small. If we don't display these columns, everything is fine. From what I can gather, an Interactive Report row has a limit of 32k, but we shouldn't be close to breaking 8k per row.
What are the actual limits for Interactive Reports, because I can't find anything solid.
