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!

TO_NUMBER format mask error

564246May 1 2007 — edited May 1 2007

Hi All,

I have some numbers stored in a varchar field. They consist of a max of 2 digits and I want to display single digit numbers with a preceeding zero using the following code:

TO_NUMBER("POLK_A_CT"."MODEBA",'099')

I am getting an ORA-01722 invalid nuumber error.

My only though was there must be non numeric charachters in the field but if I do the following I get no error:

TO_NUMBER("POLK_A_CT"."MODEBA",'999')

Anyone any clue what is happening? What am I missing?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2007

Added on May 1 2007

3 comments

350 views