26.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 26-6 UPGRADE Procedure Signature 2 Parameters
Parameter | Description |
---|---|
|
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