16.1 LOAD_SUPPORTING_OBJECT_DATA Procedure

This procedure loads the supporting object data and installs the data in the specified application. 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 16-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

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