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
Rollback Source Type	`ROLLBACK_SOURCE_TYPE`	Where to retrieve file when initiating a rollback deployment.	Project Version	Project Version, SCM Revision, Backup Repository, and Rollback File SCM Revision and Rollback File options are only available when the project has SCM details configured, and Backup Repository should only be used if the FlexDeploy server and project are configured to take backups.
Rollback File	`ROLLBACK_FILE`	The associated file to deploy which will roll back this file. Only applicable when Rollback Source Type is Rollback File		Any project file sourced from SCM

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