UNLOCK_APPLICATION Procedure

This procedure unlocks an application. When p_unlock_as_user is null, repeated calls for an unlocked application are successful.

Syntax

PROCEDURE apex_application_admin.unlock_application (
    p_application_id     IN   NUMBER,
    p_unlock_as_user     IN   VARCHAR2     DEFAULT NULL );

Parameters

Parameter	Description
p_application_id	ID of the application to unlock.
p_unlock_as_user	Optional expected lock owner. When supplied, the application must be locked by this user. This parameter is not case-sensitive.

Example

begin
    apex_application_admin.unlock_application(
        p_application_id => 100,
        p_unlock_as_user => 'DEVELOPER' );
end;