CHANGE_SUBSCRIPTION_LANG Procedure

34.6 CHANGE_SUBSCRIPTION_LANG Procedure

This procedure changes the interactive report subscription language.

Syntax

APEX_IR.CHANGE_SUBSCRIPTION_LANG (
    p_subscription_id IN NUMBER,
    p_language        IN VARCHAR2 )

Parameters

Parameter	Description
`p_subscription_id`	Subscription ID to change the language within the current workspace.
`p_language`	This is an IANA language code. Some examples include: `en`, `de`, `de`-`at`, `zh`-`cn`, and `pt`-`br`.

Example

The following example shows how to use the CHANGE_SUBSCRIPTION_LANG procedure to change the subscription with the ID of 567890123 to German in the current workspace.

BEGIN     
    APEX_IR.CHANGE_SUBSCRIPTION_LANG(
        p_subscription_id => 567890123,
        p_language        => 'de');
END;

Parent topic: APEX_IR