This procedure resets report settings using the report alias.
Syntax
APEX_IR.RESET_REPORT( p_page_id IN NUMBER, p_region_id IN NUMBER, p_report_alias IN VARCHAR2 DEFAULT NULL);
Parameters
Table 11-11 describes the available parameters for the RESET_REPORT procedure signature 2.
Table 11-11 RESET_REPORT Procedure Signature 2 Parameters
Parameter | Description |
---|---|
|
Page of the current Application Express application that contains an interactive report. |
|
The interactive report region ID. |
|
The saved report alias within the current application page. If |
Example
The following example shows how to use the RESET_REPORT
procedure to reset interactive report settings with a report alias of CATEGORY_REPORT
in page 1, region 2505704029884282 of the current application.
BEGIN APEX_IR.RESET_REPORT( p_page_id => 1, p_region_id => 2505704029884282, p_report_alias => 'CATEGORY_REPORT'); END;