Please help me resolve this issue.
Unable to show huge clob data (5L chars) using classic report (Value Attributes Pair - Column) using json_table query shown below. P2_DATA hidden page item contains 5L character clob which needs to be displayed using ‘Value Attributes Pair - Column’ theme.
Apex Version : 23.2
Note : Same data working perfectly fine in Interactive Report but I am in need of classic report with a specific theme
CLOB DATA
with data as (select :P2_DATA as info from dual)
SELECT jt.*
FROM data ,
JSON_TABLE(info, '$.json.content."Json Result"'
COLUMNS (nested path '$.pg[*]' columns (
pg varchar2(4000) path '$'
)
)
) jt
order by 1;
Error:
Unable to set page item source value for partial page refresh region
Contact your application administrator. Details about this incident are available via debug id "4531976".
Technical Info (only available for developers)
- is_internal_error: true
- apex_error_code: ERROR_SET_ITEM_STATE_FOR_PPR_REGION
- ora_sqlcode: -6502
- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value errorORA-06512: at "APEX_230200.WWV_FLOW_UTILITIES", line 6969 ORA-06512: at "APEX_230200.WWV_FLOW_UTILITIES", line 6905 ORA-06512: at "APEX_230200.WWV_FLOW_UTILITIES", line 6896 ORA-06512: at "APEX_230200.WWV_FLOW_SESSION_STATE", line 3841
- component.type: APEX_APPLICATION_PAGE_REGIONS
- component.id: 36422481974849716
- component.name: pg
- error_backtrace:ORA-06512: at "APEX_230200.WWV_FLOW_UTILITIES", line 6969 ORA-06512: at "APEX_230200.WWV_FLOW_UTILITIES", line 6905 ORA-06512: at "APEX_230200.WWV_FLOW_UTILITIES", line 6896 ORA-06512: at "APEX_230200.WWV_FLOW_SESSION_STATE", line 3841 ORA-06512: at "APEX_230200.WWV_FLOW", line 1093