15.1 LOAD_SUPPORTING_OBJECT_DATA Procedure

This procedure loads the supporting object data and installs the data in the specified application using the internal package. It makes use of the static files generated through the CREATE_DATA_MIGRATION procedure to carry out the installation

Syntax

APEX_DATA_INSTALL.LOAD_SUPPORTING_OBJECT_DATA (
    p_table_name            IN  VARCHAR2,
    p_delete_after_install  IN  BOOLEAN,
    p_app_id                IN  NUMBER  DEFAULT NULL);

Parameters

Table 15-1 LOAD_SUPPORTING_OBJECT_DATA Parameters

Parameter	Description
p_table_name	Name of the table where the data will be deposited.
p_delete_after_install	Indicates if files are removed after installing supporting objects. Default TRUE.
p_app_id	APEX application ID of the application that contains the static files associated with a data migration export. This can be used from SQL workshop outside the context of installing supporting objects, enabling a developer to reinstall migrated data without reinstalling all supporting objects.

Example

The following example demonstrates

DECLARE
    l_table_name    varchar2(400);
BEGIN
   wwv_data_migration_int.load_supporting_object_data(
       p_table_name            => l_table_name,
       p_delete_after_install  => true);
END;