8.50 SET_DATASET_IMPORT_MODE Procedure

This procedure sets the dataset import mode for a supplied dataset that is used to determine whether the dataset is kept or overwritten during import. By default a dataset is retained on import unless explicitly set to be overwritten.

Syntax

PROCEDURE apex_application_install.set_dataset_import_mode (
    p_static_id  IN   VARCHAR2,
    p_mode       IN   t_dataset_import_mode );

Parameters

Parameter	Description
p_static_id	Static ID used to reference the dataset.
p_mode	Dataset import mode, see t_dataset_import_mode constants

Example

The following example sets the import mode for the supplied dataset in the APEX_APPLICATION_INSTALL package.

begin
   apex_application_install.set_dataset_import_mode(
       p_static_id => 'HR',
       p_mode      => apex_application_install.c_dataset_keep );

   apex_application_install.set_dataset_import_mode(
       p_static_id => 'SALES',
       p_mode      => apex_application_install.c_dataset_overwrite );
end;