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