Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL*Loader - Please Help!!!

SQL*Loader - Please Help!!!

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 19 Dec 2000 08:17:13 -0600
Message-Id: <10715.124921@fatcity.com>


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 Received on Tue Dec 19 2000 - 08:17:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US