SQL & PL/SQL

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

user263656Jan 10 2012 — edited Feb 3 2012

Good day,
Could you kindly help me. I have the following insert statement:

 INSERT INTO GL_DAILY_RATES_INTERFACE(
                                                                          conversion_rate)
select TO_NUMBER(CONVERSION_RATE) 
from table1

I'm getting an "Invalid number" error because the CONVERSION_RATE column on table1 is a Varchar and conversion_rate column in GL_DAILY_RATES_INTERFACE is a number. So I'm trying to convert a varchar into a number, but using a TO_NUMBER(CONVERSION_RATE) does not work. What am I missing?

Below are the examples of values from table1

CONVERSION_RATE
22.29619
1.64097
2.17342
1241.84782
0.41423

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 2 2012

Added on Jan 10 2012

30 comments

8,475 views