25.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 apex_application.g_flow_id,    
    p_report_id      IN NUMBER);

Parameters

Table 25-6 DELETE_REPORT 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 apex_application.g_flow_id.
p_report_id	Report ID to delete within the current Oracle APEX 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;