31.6 UPGRADE Procedure Signature 2

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_name IN VARCHAR2 );

Parameters

Table 31-6 UPGRADE Procedure Signature 2 Parameters

Parameter	Description
p_app_name	The case insensitive packaged application name.

Example

The following example shows how to use UPGRADE procedure to upgrade packaged application ‘Bug Tracking' in DEMO workspace.

begin
    APEX_UTIL.SET_WORKSPACE( 'DEMO' );
    APEX_PKG_APP_INSTALL.UPGRADE( 
        p_app_name => 'Bug Tracking' );
end;