This procedure suspends background page processing for an application. This procedure is intended for use before upgrades.

This procedure enables orderly application upgrades by waiting for all SCHEDULED or EXECUTING background executions to complete then locking out subsequent processes until after the upgrade. During the time when background executions are suspended for an application, new executions can be enqueued, but are not executed, until the lock releases.

The lock releases when the transaction ends with a COMMIT or ROLLBACK operation.

Syntax

APEX_APPLICATION_INSTALL.SUSPEND_BACKGROUND_EXECS (
    p_application_id     IN NUMBER )

Parameters

Example

BEGIN
    apex_application_install.suspend_background_execs(
       p_application_id => 100 );
END;