IR_RESET Procedure (Deprecated)

Note: The use of this procedure is not recommended. This procedure has been replaced by the procedure in APEX_IR.

This procedure resets report settings back to the default report settings. Resetting a report removes any customizations you have made.

Note: This procedure should be used only in a page submit process.

Syntax

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

Parameters

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

Example

The following example shows how to use the IR_RESET procedure to reset Interactive report settings with alias of ‘8101021’ in page 1 of the current application.

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