REMOVE_SAVED_REPORTS procedure removes all user saved interactive report settings for a particular application or for the entire instance.
APEX_INSTANCE_ADMIN.REMOVE_SAVED_REPORTS( p_application_id IN NUMBER DEFAULT NULL);
Table 11-11 REMOVE_SAVED_REPORTS Parameters
The ID of the application for which to remove user saved interactive report information. If this parameter is left null, all user saved interactive reports for the entire instance is removed.
The following example demonstrates how to use the
REMOVE_SAVED_REPORTS procedure to remove user saved interactive report information for the application with an ID of 100.
BEGIN APEX_INSTANCE_ADMIN.REMOVE_SAVED_REPORTS(100); END;