DELETE_SUBSCRIPTION Procedure

This procedure deletes interactive report subscriptions.

Syntax

APEX_IR.DELETE_SUBSCRIPTION(
    p_subscription_id IN NUMBER);

Parameters

Table 11-7 describes the available parameters for the DELETE_SUBSCRIPTION procedure.

---

Table 11-7 DELETE_SUBSCRIPTION Procedure Parameters

Parameter	Description
p_subscription_id	Subscription ID to delete within the current workspace.

---

Example

The following example shows how to use the DELETE_SUBSCRIPTION procedure to delete the subscription with ID of 567890123 in the current workspace.

BEGIN     
    APEX_IR.DELETE_SUBSCRIPTION(
        p_subscription_id => 567890123);
END;