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!

SQL Loader - ORA-01722: Invalid Number

548882Nov 29 2006 — edited Nov 29 2006

Hi,

i tried to load some data via the sqlldr into my Oracle 10g Express, but there seems to bee a problem with the decimal point. It's the last column which cause the error: ORA-01722 - Invalid number.

The column is of datatype float, i tried number, as well, but with no difference.

Some sample data:

20061124,24,1001,A,ST,735.4545455
20061124,24,1050,A,ST,2590.863636
20061124,24,1051,A,ST,212.2272727
20061124,24,1052,A,ST,61.40909091

The data is an export from excel as *.csv.

Thanks and Regards

Tobias

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2006

Added on Nov 29 2006

#general-database-discussions

3 comments

982 views