Skip to Main Content
Forums

Oracle Database Discussions

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!

ORA-01722 in SQL loader (decimal sign) - elegant way to solve this?

448212Nov 22 2006 — edited Nov 27 2006
I run into the famous 'invalid number' error when importing a csv file with
SQL Loader. The csv file contains decimal numbers.

error log is:
Record 1: Rejected - Error on table ODS.HA0008, column HFRACHOTENERGY_RATE.
ORA-01722: invalid number

Record 2: Rejected - Error on table ODS.HA0008, column HFRACHOTENERGY_RATE.
ORA-01722: invalid number

Record 3: Rejected - Error on table ODS.HA0008, column HFRACHOTENERGY_RATE.
ORA-01722: invalid number

I need help!

any reponse will be appreciated!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2006
Added on Nov 22 2006
#general-database-discussions
6 comments
2,318 views