• Post Reply Bookmark Topic Watch Topic
  • New Topic

My query results are ending prematurely  RSS feed

George Larry
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?
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!