IR_CLEAR Procedure

This procedure clears report settings.

Syntax

APEX_UTIL.IR_CLEAR(
    p_page_id IN NUMBER,
    p_report_alias IN VARCHAR2 DEFAULT NULL);

Parameters

Table: IR_CLEAR Parameters describes the parameters available in IR_CLEAR procedure.

IR_CLEAR Parameters

Parameter	Description
`p_page_id`	Page of the current APEX application that contains an interactive report.
`p_report_alias`	Identifies the saved report alias within the current application page. To clear a Primary report, `p_report_alias` must be 'PRIMARY' or leave as NULL. To clear a saved report, `p_report_alias` must be the name of the saved report. For example, to clear report '1234', `p_report_alias` must be '1234'.

Example

The following example shows how to use the IR_CLEAR procedure to clear Interactive report settings with alias of '8101021' in page 1 of the current application.

BEGIN
    APEX_UTIL.IR_CLEAR(
        p_page_id      => 1,
        p_report_alias => '8101021'
        );
END;