Java EE (Java Enterprise Edition) General Discussion

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!

Format number with to_char function

882656Sep 27 2011 — edited Sep 27 2011

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2011

Added on Sep 27 2011

#java-ee-sdk

2 comments

1,647 views