34.12 GET_LAST_VIEWED_REPORT_ID Function
This function returns the last viewed base report ID of the specified page and region.
Syntax
APEX_IR.GET_LAST_VIEWED_REPORT_ID (
p_page_id IN NUMBER,
p_region_id IN NUMBER );
Parameters
Table 34-9 GET_LAST_VIEWED_REPORT_ID Parameters
Parameter | Description |
---|---|
p_page_id |
Page of the current Oracle APEX application that contains an interactive report. |
p_region_id |
The interactive report region ID. |
Example
The following example shows how to use the GET_LAST_VIEWED_REPORT_ID
function to retrieve the last viewed report ID in page 1, region 2505704029884282
of the current application.
DECLARE l_report_id number; BEGIN l_report_id := APEX_IR.GET_LAST_VIEWED_REPORT_ID ( p_page_id => 1, p_region_id => 2505704029884282); END;
Parent topic: APEX_IR