Re: To_Number problem on PL/SQL 2.0 on AIX
From: AMARENDRA B NETTEM <nettama_at_charlie.acc.iit.edu>
Date: 1996/04/12
Message-ID: <316EBDF2.5AA_at_charlie.acc.iit.edu>#1/1
Date: 1996/04/12
Message-ID: <316EBDF2.5AA_at_charlie.acc.iit.edu>#1/1
Mike Chan wrote:
>
> Hi,
>
> I have problem on use funtion TO_NUMBER when I doing as following:
>
> to_number('10,000,000');
>
> but this works in my previous version of PL/SQL?
> Now it returns value_error, any idea?
>
> Thanks in advance.
>
> Best Regards,
> Mike Chanremove commas(,) and try. it works
-- AMARENDRA B NETTEM PH.No. (312)945-2116 HOMEPAGE: http://www.iit.edu/~nettama E-MAIL : nettama_at_charlie.acc.iit.eduReceived on Fri Apr 12 1996 - 00:00:00 CEST