OraFAQ Forum: Server Utilities » SQL LOADER -Ora error-01858 and 01843

Home » RDBMS Server » Server Utilities » SQL LOADER -Ora error-01858 and 01843 (oracle 10g/Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL LOADER -Ora error-01858 and 01843 [message #301824]

Thu, 21 February 2008 20:39

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

Report message to a moderator

Re: SQL LOADER -Ora error-01858 and 01843 [message #301825 is a reply to message #301824]

Thu, 21 February 2008 21:47

Barbara Boehmer
Messages: 9094
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.

Report message to a moderator

Re: SQL LOADER -Ora error-01858 and 01843 [message #302096 is a reply to message #301825]

Sat, 23 February 2008 07:13

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

Report message to a moderator

Previous Topic:	Special Language Character
Next Topic:	How to load mutiple Variable length flat files into multiple tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 03:43:59 CDT 2024