21.6 DELETE_REPORT Procedure

This procedure deletes a saved interactive grid report. It deletes a specific saved report in the current logged in workspace and application.

Syntax

APEX_IG.DELETE_REPORT(
    p_application_id IN NUMBER DEFAULT wwv_flow.g_flow_id,    
    p_report_id      IN NUMBER);

Parameters

Table 21-6 DELETE_REPORT Procedure Parameters

Parameter Description

p_application_id

The application ID containing the interactive grid. If p_application_id is NULL, it defaults to the application ID in wwv_flow.g_flow_id.

p_report_id

Report ID to delete within the current Application Express application.

Example

The following example shows how to use the DELETE_REPORT procedure to delete the saved interactive grid report with ID of 901029800374639010 in application ID 100.

BEGIN
    APEX_IG.DELETE_REPORT (
        P_application_id => 100,
        p_report_id      => 901029800374639010);
END;