Column not found before end of logical record (use TRAILING NULLCOLS)
Column not found before end of logical record (use TRAILING NULLCOLS
Hi,
I have reached end of my input file still the sqlloader tries to read new record. sample ctl file is as follows:
load data
infile 'zzzz.xml' "str '</Match>'"
truncate
into table matchxx
(
team_prn enclosed by "<Match BetradarMatchID=\"" and "\">",
extra1 filler terminated by "<Fixture>",
extra2 filler terminated by "<COMPETITORS>",
....
....
extra46 filler terminated by "</LiveMultiCast>",
dummy filler terminated by "</Match>"
)
I had 2 records and got processed but get the following error
Record 3: Rejected - Error on table MATCHXX, column EXTRA1.
Column not found before end of logical record (use TRAILING NULLCOLS)
Hi,
I have reached end of my input file still the sqlloader tries to read new record. sample ctl file is as follows:
load data
infile 'zzzz.xml' "str '</Match>'"
truncate
into table matchxx
(
team_prn enclosed by "<Match BetradarMatchID=\"" and "\">",
extra1 filler terminated by "<Fixture>",
extra2 filler terminated by "<COMPETITORS>",
....
....
extra46 filler terminated by "</LiveMultiCast>",
dummy filler terminated by "</Match>"
)
I had 2 records and got processed but get the following error
Record 3: Rejected - Error on table MATCHXX, column EXTRA1.
Column not found before end of logical record (use TRAILING NULLCOLS)
0