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 |
---|---|
|
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