2 Replies Latest reply: Sep 27, 2011 3:21 PM by 796440 RSS

    Format number with to_char function

    882656
      Hi,

      I don't know why is this statement giving me lots of trouble, I'm pretty sure the values on this field are fine. Any ideas?
        UPDATE temp_dev
        SET monto= to_char(monto, '9999999999999990.99');
        COMMIT;
      in fact, if I call this procedure from SQL Developer it works fine, but when I call this procedure from java it raises an exception...

      Appreciate your help,

      FHML