10 Replies Latest reply on Oct 26, 2011 4:36 AM by Mikail

    Invalid number when using to_number function

    Mikail
      Hi,
      Both in SQL*Plus and SQL Deveoper when I type and run

      select to_number('1234.64','9999.9') from dual;

      I get ORA-01722: invalid number error. What can be the reason for this error?