REMOVE_LOADER_COLUMNΒΆ

Delete records from table DBI_LOADER_COLUMNS using PK (single record delete).

Parameter Name

Required

DefaultValue

Description

p_ldr_name

yes

.

(is part of PK) Name of the loader process for a specific data table as defined in DBI_LOADER.LDR_NAME (foreign key)

p_column_name

yes

.

(is part of PK) Name of the column that needs data type conversion during the load process

Example

EXECUTE SCRIPT api_dbiadm.remove_loader_column
           ( 'myLdr_Name'     -- p_ldr_name
           , 'myColumn_Name'  -- p_column_name
           );