Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERR: a non-numeric character was found where a numeric was expected

955015Feb 15 2013 — edited Mar 6 2013

Hi,

I am trying to load data from csv to oracle while loading it is giving me a error like

ORA-01858: a non-numeric character was found where a numeric was expected

1. I have 3 date columns in source, I converted them into date
e.g.
to_date(DAT.CALENDAR_DATE,'MM/DD/YYYY')

2. some of them are numeric which I converted them into number
e.g.
to_number(DAT.WEEK)

Still it is giving the same error.

Please share your valuable suggestions..

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2013

Added on Feb 15 2013

#business-intelligence-applications, #data-integrator, #system-management-and-integration

4 comments

426 views