Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Inserted value too large for column  RSS feed

 
Carty Ellis
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Carty Ellis
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Nevermind" as Emily Latella would say -
Whoops. I found it.
 
Rudy Dakota
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!