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

Parent topic: APEX_PKG_APP_INSTALL