IR_CLEAR Procedure (Deprecated)

59.83 IR_CLEAR Procedure (Deprecated)

Note:

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

This procedure clears report settings. Only use this procedure in a page submit process.

Syntax

APEX_UTIL.IR_CLEAR (
    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.

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 clear a Primary report, set `p_report_alias` to `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`, set `p_report_alias` to `1234`.

p_report_alias

Identifies the saved report alias within the current application page.

To clear a Primary report, set p_report_alias to 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, set p_report_alias to 1234.

Example

The following example clears 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;

Parent topic: APEX_UTIL