28.5 UPGRADE Procedure Signature 1

This procedure upgrades specified packaged application. If any of the following are true, the procedure raises an error:

• Invalid packaged application ID passed.

• The installed packaged application is unlocked and cannot be upgraded.

• The installed packaged application is up to date and no upgrade needed.

Syntax

APEX_PKG_APP_INSTALL.UPGRADE(
    p_app_id IN NUMBER );

Parameters

Table 28-5 UPGRADE Procedure Signature 1 Parameters

Parameter	Description
p_app_id	The packaged application ID.

Example

The following example shows how to use UPGRADE procedure to upgrade packaged application ID 7060 in DEMO workspace.

begin
    APEX_UTIL.SET_WORKSPACE( 'DEMO' );
    APEX_PKG_APP_INSTALL.UPGRADE( 
        p_app_id => 7060 );
end;