8.62 SET_SUBSCRIPTION_MODE Procedure

Use this procedure to instruct how subscriptions should be handled during the application installation process. By default, Oracle APEX uses apex_application_install.c_subscription_strict as subscription mode. This default value can be overwritten using instance level parameter IMP_DEFAULT_SUBSCRIPTION_MODE.

Syntax

APEX_APPLICATION_INSTALL.SET_SUBSCRIPTION_MODE (
    p_mode                   IN              t_subscription_mode);

Parameters

Parameter	Description
p_mode	Subscription installation mode, see t_subscription_mode constants.

Example

The following example demonstrates installing an application and changing subscription mode to ignore subscriptions

begin
    apex_application_install.clear_all;
    apex_application_install.set_workspace('TARGET_WORKSPACE');

    apex_application_install.set_subscription_mode(
        p_mode => apex_application_install.c_subscription_remove );
end;