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 problem

selezeusAug 20 2007 — edited Aug 20 2007

Hello everybody.
Im working with Oracle Database 10G 10.1.2.0.2 and SqlDeveloper version 1.2.0 in Linux

I have a problem converting varchar2 to numbers.

The problem come only when the number have decimal characters. Not mind what class '.' or ',' , any of those give ora-6502.

by example :

pxp := precio /* if precio = '.853' or precio = ',853' in both case it give conversion error.

What I must to do? How I can resolve this?

thanks in advanced.
Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2007

Added on Aug 20 2007

4 comments

600 views