Does anyone know the limitations of the report queries (for OBIEE integration with report layouts)? I created a report query with about 30 output columns. when I use the "Test Report", I get "ORA-06502: PL/SQL: numeric or value error: character string buffer too small". I can remove about 8 columns - I've removed the first 8, the last 8, middle 8 - and test report function works. I've tried aliasing all the columns with one character values to reduce the xml tags. Still no luck. I'm about ready to punt and just use a classic report to create the XML and attach the PDF output. Or maybe concatenate report columns together and split them out in the layout.
This is on Apex 20.1
When trying to execute the report query from a button on the page, I get this error:
is_internal_error: true
apex_error_code: APEX.UNHANDLED_ERROR
ora_sqlcode: -6502
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APEX_200100.WWV_FLOW_RENDER_QUERY", line 1784 ORA-06512: at "APEX_200100.WWV_FLOW_RENDER_QUERY", line 1900
component.type: APEX_APPLICATION_PAGES
component.id: 724000000000
component.name: Global Page - Desktop
error_backtrace:
ORA-06512: at "APEX_200100.WWV_FLOW_RENDER_QUERY", line 1784
ORA-06512: at "APEX_200100.WWV_FLOW_RENDER_QUERY", line 1900
ORA-06512: at "APEX_200100.WWV_FLOW", line 2956