31.4 INSTALL Function Signature 2
true
, the function raises an error:
-
Invalid packaged application ID passed.
-
Invalid authentication type passed. For list of available authentication types, query
APEX_PKG_APP_AUTHENTICATIONS
view.
Syntax
APEX_PKG_APP_INSTALL.INSTALL(
p_app_name IN VARCHAR2,
p_authentication_type IN apex_authentication.t_authentication_type DEFAULT NULL,
p_schema IN VARCHAR2 DEFAULT NULL ) RETURN NUMBER;
Parameters
Table 31-4 INSTALL Function Signature 2 Parameters
Parameter | Description |
---|---|
|
The case insensitive packaged application name. |
|
The type of authentication to use. If |
|
The database schema the application parses SQL statements as. If |
Example
The following example shows how to use INSTALL
function to install packaged application named 'Bug Tracking'
in DEMO workspace with 'Application Express Account'
authentication using ‘SCOTT’
schema.
declare
l_installed_app_id number;
begin
APEX_UTIL.SET_WORKSPACE( 'DEMO' );
l_installed_app_id := APEX_PKG_APP_INSTALL.INSTALL(
p_app_name => 'Bug Tracking',
p_authentication_type => APEX_AUTHENTICATION.C_TYPE_APEX_ACCOUNTS,
p_schema => 'SCOTT' );
end;
Parent topic: APEX_PKG_APP_INSTALL