This procedure changes interactive report subscriptions email address. When an email is sent out, the subscription sends message to the defined email address.
APEX_IR.CHANGE_SUBSCRIPTION_EMAIL ( p_subscription_id IN NUMBER, p_email_address IN VARCHAR2);
Table 12-3 CHANGE_SUBSCRIPTION_EMAIL Parameters
Subscription ID to change the email address within the current workspace.
The new email address to change to. The email address needs to be a valid email syntax and cannot be set to null.
The following example shows how to use
CHANGE_SUBSCRIPTION_EMAIL procedure to change the email address to
firstname.lastname@example.org for the interactive report subscription 956136850459718525.
BEGIN APEX_IR.CHANGE_SUBSCRIPTION_EMAIL ( p_subscription_id => 956136850459718525, p_email_address => 'email@example.com'); END;