6.48 SUSPEND_BACKGROUND_EXECS Procedure

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

Table 6-9 SUSPEND_BACKGROUND_EXECS Parameters

Parameter	Description
p_application_id	The application ID.

Example

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