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 |
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;
Parent topic: APEX_DATA_INSTALL