Home » RDBMS Server » Server Utilities » SQL LOADER -Ora error-01858 and 01843 (oracle 10g/Windows XP)
SQL LOADER -Ora error-01858 and 01843 [message #301824] Thu, 21 February 2008 20:39 Go to next message
mandys
Messages: 14
Registered: February 2008
Location: Pittsburgh
Junior Member
Hi,
I am using SQL LOADER for the first time.I am trying to load data
from a CSV file.
This is my control file:
Load Data
Infile 'c:\stcity\stcity_1234.csv'
BADFILE 'c:\stcity\stcity.bad'
DISCARDFILE ''c:\stcity\stcity.discard'
APPEND
INTO TABLE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(old_name,
old_address1,
old_address2,
old_id filler,
old_phone filler,
old_fax filler,(I dont need these field in my table)
sdate date(I tried using TO_DATE)
)
(I am getting ORA ERROR-01858 and ORA 01843 )A non-numeric character was found where numeric is expected.)

Thanks,
Mandy

Re: SQL LOADER -Ora error-01858 and 01843 [message #301825 is a reply to message #301824] Thu, 21 February 2008 21:47 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
What is your table structure and sample data? In general, you get this sort of error when you are trying to put non-numeric (character) data in a numeric column. I also noticed that you have mismatched quotes around your discard file name, but that may be a typo.
Re: SQL LOADER -Ora error-01858 and 01843 [message #302096 is a reply to message #301825] Sat, 23 February 2008 07:13 Go to previous message
mandys
Messages: 14
Registered: February 2008
Location: Pittsburgh
Junior Member
Hi Barbara,
I fixed it..After I specified the format for the date i.e
SDATE DATE "MM/DD/YYYY"

Thanks!!!
Mandy
Previous Topic: Special Language Character
Next Topic: How to load mutiple Variable length flat files into multiple tables
Goto Forum:
  


Current Time: Fri Dec 09 19:23:20 CST 2016

Total time taken to generate the page: 0.06205 seconds