• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error Numeric Overflow-oracle

 
archana gangaiah
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm using oracle 10g.

I am trying to get the sum of count of a column based on some collection column which is passed at run time using preparedStatement.
here is my code. The query works fine in sqldeveloper.


please help me....Thnks in adv
 
archana gangaiah
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually, I was trying to insert too big value for that column's datatype scale....:-)
 
Jan Cumps
Bartender
Posts: 2586
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you give us the complete error message?

And this line of code: collection1.add(resultSets.getString(2));
You select field 2 from the query, but the statement returns one field.
 
archana gangaiah
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I forgot to comment that line while posting ... It is working..... Thanks for pointing out
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic