Skip to Main Content
Forums

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 function return error in pl/sql

hlthanhAug 27 2011 — edited Aug 27 2011
Hello,
I don't have a prob when running select to_number('1234.56') from dual
But this stm return error Invalid number in procedure unless I use select to_number('1234.56','9999999.99') from dual
Please help me out.
Do I have to set parameter in DB ?
BTW: my NLS_NUMERIC_CHARACTER is set to '.,'
Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2011
Added on Aug 27 2011
5 comments
345 views