This week's giveaway is in the Java/Jakarta EE forum.
We're giving away four copies of Java EE 8 High Performance and have Romain Manni-Bucau on-line!
See welcome thread
Win a copy of Java EE 8 High Performance this week in the Java/Jakarta EE forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

My query results are ending prematurely  RSS feed

Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm using calling a few Oracle PL/SQL procedures from my JSP page. Everything seems to be working... until it all just ends.
I'm selecting a long list of items from the db. When I run the page the query appears to be running just fine- selecting everything it's supposed to, but then it just ends. Nowhere in particular- sometimes mid-word. There are no errors... it just ends. I need to use procedures, because most of my queries are longer than 256 char. There are a few queries that are shorter and I've tried running them straight from the JSP (not using a procedure) and they complete. I run the exact same query from a procedure and they get cut off.
Why would this happen? How can I fix it?
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!