LOCK_APPLICATION Procedure

This procedure locks an application as the specified workspace developer or administrator.

A repeated request by the same developer succeeds and updates the lock comment when supplied. A request for an application locked by another developer raises an already-locked error.

Syntax

PROCEDURE apex_application_admin.lock_application (
    p_application_id     IN   NUMBER,
    p_lock_as_user       IN   VARCHAR2,
    p_lock_comment       IN   VARCHAR2 );

Parameters

Parameter	Description
p_application_id	ID of the application to lock.
p_lock_as_user	Existing workspace developer or administrator to record as the application lock owner.
p_lock_comment	Optional comment associated with the lock.

Example

begin
    apex_application_admin.lock_application(
        p_application_id => 100,
        p_lock_as_user   => 'DEVELOPER',
        p_lock_comment   => 'Editing in progress' );
end;