CHANGE_SUBSCRIPTION_EMAIL Procedure

34.5 CHANGE_SUBSCRIPTION_EMAIL Procedure

This procedure changes the interactive report subscription's email address. When an email is sent out, the subscription sends a message to the defined email address.

Syntax

APEX_IR.CHANGE_SUBSCRIPTION_EMAIL (
    p_subscription_id   IN NUMBER,
    p_email_address     IN VARCHAR2 );

Parameters

Parameter	Description
`p_subscription_id`	Subscription ID to change the email address within the current workspace.
`p_email_address`	The new email address to change to. The email address needs to be a valid email syntax and cannot be set to null.

Example

The following example shows how to use the CHANGE_SUBSCRIPTION_EMAIL procedure to change the email address to some.user@example.com for the interactive report subscription 956136850459718525.

BEGIN
    APEX_IR.CHANGE_SUBSCRIPTION_EMAIL (
        p_subscription_id => 956136850459718525,
        p_email_address   => 'some.user@example.com');
END;

Parent topic: APEX_IR