| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Loader - Please Help!!!
Ron,
Is the column trully blank? If so, you can probably use a NULLIF condition in the SQLLDR file. I don't remember the exact format, something like:
NULLIF columnname = ' '.
Bob VanderMey
Oracle DBA
Works.com
847 573-2687
bvandermey_at_works.com
565 Lakeview Parkway, Suite 250
Vernon Hills, IL 60061
http://www.works.com
-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith_at_kmg.com]
Sent: Tuesday, December 19, 2000 8:16 AM
To: Multiple recipients of list ORACLE-L
Subject: SQL*Loader - Please Help!!!
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: rlsmith_at_kmg.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 19 2000 - 09:58:52 CST
 |
 |