25.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 25-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;

Parent topic: APEX_PKG_APP_INSTALL