Database Administration (MOSC)

MOSC Banner

Column not found before end of logical record (use TRAILING NULLCOLS)

edited Nov 5, 2008 6:14AM in Database Administration (MOSC) 2 commentsAnswered
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center