36.1 CLEAR Procedure
This procedure clears region settings (that is, CR and IR pagination, IR report settings).
For interactive report regions, this procedure clears the following settings: control break, aggregate, flashback, chart, number of rows to display, filter, highlight, computation, and group by. However, it does not clear the following: display column list, sorting, report preference (such as view mode, display nulls in detail view, expand/collapse of report settings).
Syntax
APEX_REGION.CLEAR (
p_application_id IN NUMBER DEFAULT apex_application.g_flow_id,
p_page_id IN NUMBER,
p_region_id IN NUMBER,
p_component_id IN NUMBER DEFAULT NULL );
Parameters
Table 36-1 CLEAR Parameters
Parameter | Description |
---|---|
|
|
|
|
|
|
|
Region component |
Example
This example clears the given saved report on application 100, page 1.
BEGIN
APEX_REGION.CLEAR (
p_applicatoin_id => 100,
p_page_id => 1,
p_region_id => 2505704029884282,
p_component_id => 880629800374638220);
END;
Parent topic: APEX_REGION