"Smith, Ron L." wrote:
>
> I am trying to run SQL*Loader on 8.1.6 NT. One column in the table is a
> date format. In the SQL*Loader control file I defined the column as "DATE".
> However, the input file is blank in the date column. The column can be null
> according to the table structure. When I try to load the data I get an
> error message that says there is an invalid value for month in the date
> column. There is no format associated with the column and again, the date
> column is blank.
>
> Ron Smith
> Database Administration
> rlsmith_at_kmg.com
but a blank is not a null. if it's a blank the it's looking for it to
fit the default date mask. i think there's a way to insert a null if
the column i s blank, but i haven't used loader in a long time and the
memory is subject to bit rot. sorry.
--
Bill Thater Sr. ORACLE DBA
Telergy, Inc thaterw_at_telergy.net
-------------------------------------------
"Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former." -- Albert Einstein
-------------------------------------------
Received on Tue Dec 19 2000 - 08:37:23 CST
