Skip to Main Content
Forums

Database 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!

ORA-01722: invalid number - when last column has numbers that has a decimal seperator

Srini RamaswamyOct 26 2013 — edited Nov 3 2013

Below is the sample data -

FRT,1.64,VAT,23.36

FRT,1.64,VAT,23.36

When I try to convert 1.64 to to_number all is good but when I do the same with 23.36 I get the following error

ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-01722: invalid number

ORA-06512: at "SYS.ORACLE_LOADER", line 52

I tried this query as well

select to_number(CONSIGNMENT_NET_VALUE) as Col1 from DUMP_EXT

select to_number(CONSIGNMENT_NET_VALUE,'9999999999D99999','NLS_NUMERIC_CHARACTERS='',.''' ) as Col1 from DUMP_EXT --> 268906.1

getting the same error - any help greatly appreciated.

T.

Srini
This post has been answered by Barbara Boehmer on Nov 3 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2013
Added on Oct 26 2013
#11g, #database-key-features, #export-import-sql-loader-external-tables
8 comments
8,730 views