Re: SQL*Loader problem

Don't think that'd work.
If you look at the log, SQLLDR complains about the missing data and suggests the solution: TRAILING NULLCOLS

So try:

FIELDS TERMINATED BY ','
TRAILING NULLCOLS
( f1,
  f2,
  XXX "NVL(:xxx,'YYY')"
)

Note you can put your custom pl/sql function in place of that NVL to be called from sqlldr.

--
Robert Chin



> If I understand your question, writing the literal value in for the field

> position should solve your problem.

>

> FIELDS TERMINATED BY ','

> (f1, f2,'xxx')