sql*loader

I want to load some tables with data from a text-file In the text-file there is a date-field 'dt_start' of the format DD/MM/YYYY, but it can hold NULLS.

I am using SQL-Loader

Control-file=
  load data
  infile xxxx
  insert
  into table zzzz
  fields terminated by '|'
  ( dt_start date nvl(:dt_start, to_date('31/12/2382', 'DD/MM/YYYY')   , dt_end date
  )

Date-file=
  |01/07/1983
(the first column in the text-file = NULL)

Using this, the result in the tableis as following: dt_start = 31/12/0082 ?????????
dt_end = 01/07/1983

If i do a likewise insert on the table with sqlplus then dt_start = 31/12/2382
( columndef: dt_start date default to_date('31/12/2382', 'DD/MM'YYYY')
not null)

Any suggestions? Received on Tue May 20 2003 - 23:56:31 CEST