36.10 CLEAR_REPORT Procedure Signature 3

This procedure clears report settings using the report Static ID.

Note:

The use of this procedure in a page rendering process causes report download issues (CSV, HTML, Email, and so on). When a user downloads the report, the interactive report reloads the page with download format in the REQUEST value. Any interactive report settings changes (such as add filter or reset report) are done in a partial page refresh. Thus, the download data may not match the report data user is seeing. For this reason, Oracle recommends only using this procedure in a page submit process.

Syntax

APEX_IR.CLEAR_REPORT (
    p_page_id            IN   NUMBER,
    p_region_static_id   IN   VARCHAR2,
    p_report_static_id   IN   VARCHAR2     DEFAULT NULL );

Parameters

Parameter	Description
p_page_id	Page of the current Oracle APEX application that contains an interactive report.
p_region_static_id	The interactive report region Static ID.
p_report_static_id	The saved report Static ID within the current application page. If p_report_static_id is NULL, it clears the last viewed report settings.

Example

The following example shows how to use the CLEAR_REPORT procedure to clear the interactive report with report alias of category-report in page 1, region Static ID group-region of the current application.

BEGIN     
    APEX_IR.CLEAR_REPORT(
        p_page_id          => 1,
        p_region_static_id => 'group-region',
        p_report_static_id => 'category-report' );
END;