I have a code:
DECLARE
l_export apex_data_export.t_export;
l_region_id NUMBER;
l_format apex_data_export.t_format;
v_job_name VARCHAR2(100);
v_cnt NUMBER;
v_ind NUMBER;
l_report_id NUMBER;
BEGIN
--apex_session.attach(p_app_id => 120, p_page_id => 18, p_session_id => 6148180542393);
apex_session.create_session(p_app_id => 137, p_page_id => 29, p_username => 'USR');
SELECT
region_id
INTO l_region_id
FROM
apex_application_page_regions
WHERE
application_id = 137
AND page_id = 29
AND static_id = 'TEST';
l_report_id := apex_ig.get_last_viewed_report_id(p_page_id => 29, p_region_id => l_region_id);
dbms_output.put_line('Report id ' || l_report_id);
l_export := apex_region.export_data(p_format => 'XLSX', p_page_id => 29, p_region_id => l_region_id, p_component_id => l_report_id);
END;
/
I get an error:
ORA-01403: no data found
ORA-06512: at "APEX_220100.WWV_FLOW_REGION", line 1019
ORA-06512: at "APEX_220100.WWV_FLOW_INTERACTIVE_GRID", line 5224
ORA-06512: at "APEX_220100.WWV_FLOW_INTERACTIVE_GRID", line 11023
ORA-06512: at "APEX_220100.WWV_FLOW_REGION", line 961
ORA-06512: at "APEX_220100.WWV_FLOW_REGION_API", line 142
If I use Intracite report in the same way then it is ok.
Database is Oracle 19c.
APEX 22.1.7.
Any idea about the error?