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?
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?
