EBS Object Types - SQL*Loader

SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the data file.

Object Type Identification

  • Files with extensions .dat, .ctl, .ldr are included regardless of location

File Extensions 

Name

Description

Name

Description

.dat

.ctl

.ldr

SQL*Loader is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database.

Object Type

Name

Code

Name

Code

SQL*Loader

SQL_LDR

Object Type Attributes

Name

Code

Description

Default Value

Supported Values

Name

Code

Description

Default Value

Supported Values

Source

SOURCE

Object Source Location Type

SCM

SCM

Target Location

TARGET_LOCATION

Path to where the file should be deployed.

$<PROD_TOP>/bin/



Log File

LOG_FILE

Configuration file used to download/upload data.

loader.log



Data File

DATA_FILE

Specifies the name of the datafile containing the data to be loaded.





Execute SQL Loader

EXECUTE_LDR

Should SQL Loader be executed

false



Target File Permissions

FILE_PERMISSIONS

Permissions to apply to the file after it is deployed

Defaults to the project property FDEBS_FILE_PERMISSIONS



Related Project Properties

Name

Code

Description

Default Value

Name

Code

Description

Default Value

SQL*Loader Root Source Directory

FDEBS_SQL_LDR_ROOT_SOURCE_DIR

Source folder for control (ctl) files (e.g. control).

sqlldr

SQL*Loader Root Destination Directory

FDEBS_SQL_LDR_ROOT_DESTINATION_DIR

(Not used currently)

$<PROD_TOP>/admin/bin

File Permissions

FDEBS_FILE_PERMISSIONS

Target File Permission. Will be set to target file after deployment using chmod. eg: 755



Sample Build Commands 

N/A - Build commands are not supported for this type.

Sample Deploy Commands 

cp "$SOURCE_FILE" "$XXHR_TOP/bin/"; sqlldr userid=$FDEBS_DB_USER/$FDEBS_DB_PASSWORD control="$XXHR_TOP/bin/sqlloader.ldr" log=loader.log
The following macros are not currently supported in the footer:
  • style