APEX

Hi everyone,

I used GET_REPORT function of APEX_IR API,

DECLARE

l_report apex_ir.t_report;

l_query varchar2(32767);

BEGIN

l\_report := APEX\_IR.GET\_REPORT (

                p\_page\_id => 2,

                p\_region\_id => 188860405481180527,

                p\_report\_id => ???????);

l\_query := l\_report.sql\_query;

sys.htp.p('Statement = '||l\_report.sql\_query);

for i in 1..l\_report.binds.count

loop

    sys.htp.p(i||'. '||l\_report.binds(i).name||' = '||l\_report.binds(i).value);

end loop;

END;

and i want to know how can i get report_id parameter.

I already executed this query to get region_id and

select *

from APEX_APPLICATION_PAGE_IR

where application_id=110

order by page_id;

| APPLICATION_ID | APPLICATION_NAME | PAGE_ID | INTERACTIVE_REPORT_ID | REGION_ID | REGION_NAME |
| 110 | IG | 2 | 188860573700180528 | 188860405481180527 | emp_110 |

but the get this ajax error, when i lunch application

Thank you for help.