1 2 Previous Next 17 Replies Latest reply: May 17, 2010 8:41 AM by 800636 RSS

    Number format trouble --(double value taking scientific form)

    843789
      I am working on a application in which it involves reading from a file and adding the numeric values and store in the database and retreive in another screen. I am using the datatype double to store the amounts. But when the program inserts the value in the database the insert script generated by the program looks like the one below

      insert into tbl_tb(Account,type,actual_trans,openbal)values('1000_1234_20213','debit','4.90783584E8','0.0')

      This gives me a error at the database side " cannot convert string to numeric" The datatype for the actual_trans on the database is numeric(18,2).If i make it to varchar2 it workks but there is much of calculations and i get a variance when i do add using the parsing and all.

      Pls help me out

      Thanks
        1 2 Previous Next