Problem with SQLLDR (ORA-01008: not all variables bound)
Created Control and Data files for SQL Loader. When I tried to load data using the control and data files from my desktop (Command Prompt using SQLLDR utility), data loaded without any issue. Then I created a concurrent program and copied control and data files to required locations and launched the program.Data is not loaded into table and log file shows below error.
ORA-01008: not all variables bound
Control File:
=========
OPTIONS (SKIP = 1)
LOAD DATA
INFILE '$FILE'
APPEND
INTO TABLE XXLLNW_LIOS_DL_T
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
"SD_SNO" FILLER,