I am accessing an Oracle DB via JDBC - Database column defined as num(6,4). Data coming into the program is a string "010000" which I handle with: int iscale = NumberUtils.stringToInt(StringUtils.substring((inList.get(i+2)).toString(),5,11)); munitscale = (float) iscale / 10000; When I System.out.println(munitscale) I get 1.0 for a value. However when I try to insert that value into the database column I get an "ORA-1401 Inserted value too large for column." I am NOT using a prepared statement - the one place I need prepared I am handling with an escape clause (ts) - TimeStamp. Any suggestions?
Joined: Oct 04, 2003
"Nevermind" as Emily Latella would say - Whoops. I found it.
Joined: Jul 27, 2002
Hi Carty, You might want to share it with those among us that were puzzled by your initial post. Share and learn! Good riding, Rudy.