Re: To_Number problem on PL/SQL 2.0 on AIX

In <316E7718.2537_at_hk.super.net>, Mike Chan <mikec_at_hk.super.net> writes:
>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 Chan

Try using a format mask for the number since you have commas in the original. ie to_number('10,000,000','99,999,999')

D. Scott Moyer, Jr.                        dmoyer_at_gpu.com (work)
GPU Service Corporation                dsmoyer_at_enter.net (home)