Use this procedure to install an application. Use the
APEX_APPLICATION_INSTALL_INSTALL.SET% procedures to configure
PROCEDURE INSTALL ( p_source IN apex_t_export_files default null, p_overwrite_existing IN BOOLEAN default false );
Table 4-5 INSTALL Parameters
The source code, a table of (name, contents) with a single record for normal Oracle Applicatino Express applications or multiple records for applications that were split when exporting.
Note that passing multiple applications is not supported. If null (the default), import the source that was previously passed to GET_INFO.
If false (the default), raise an error instead of overwriting an existing application.
WWV_FLOW_IMP_PARSER.RUN_STMT_ERROR: The source contains invalid statements.
SECURITY_GROUP_ID_INVALID: The current workspace conflicts with the install workspace.
WWV_FLOW_API.FLOW_ID_RESERVED_FOR_OTHER_WORKSPACE: The application ID isused in another workspace.
WWV_FLOW_API.FLOW_ID_RANGE_RESERVED: The application ID is reserved internal us.
WWV_FLOW_API.FLOW_ID_OUT_OF_RANGE: The application ID used for installing is not in a valid range.
APPLICATION_ID_RESERVED: The application ID is in use in the current workspace and p_overwrite_existing was set to false.
Fetch an application from a remote URL, then install it with a new ID and new component ID offsets in workspace EXAMPLE.
declare l_source apex_t_export_files; l_info apex_application_install.t_file_info; begin l_source := apex_t_export_files ( apex_t_export_file ( name => 'f100.sql', contents => apex_web_service.make_rest_request ( p_url => 'https://www.example.com/apps/f100.sql', p_http_method => 'GET' ))); apex_util.set_workspace('EXAMPLE'); apex_application_install.generate_application_id; apex_application_install.generate_offset; apex_application_install.install ( p_source => l_source ); end;