• 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: 2620
14
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
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!