Hi,
I am trying to load three columns data from a flat file to Oracle table using SQLLDR.
Below is the sample data file
"00000A055","BOSS INCORPORATED","BOSS G",
"00000-057",""AMIT" CONSTRUCTION INC"," SMITH G.",
"00000-007",""POL" BCER, INC.","James T ",
Only 1st row got loaded into the table. Other two records are rejected with error “column BName. no terminator found after TERMINATED and ENCLOSED field”. Could you help on how to handle this ?
Control file script I have used
LOAD DATA
INFILE " file "
APPEND
INTO TABLE table_name
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
BId NULLIF BId =BLANKS,
BName NULLIF BName=BLANKS,
PersonName NULLIF PersonName=BLANKS
)