Handle bulk collect collection in Java
Posted on 2008-06-25
Hi to all!
I am trying to use PL/SQL to add search functionality to my Java WebApp. To do this I make the whole database manipulations (search, retrieval and results storing in PL/SQL) and show the results on a webpage using a resultset in a bean. Among all the PL/SQL routines I have a stored function that returns more than one record. To read this records in Java I used cursors in PL/SQL and the OracleTypes.CURSORS in Java. The problem with this is that I need to leave the cursors open in order for this to function at all, whcih leaves me with an error when the maximum count of open cursors is exceeded. So my question is, if I use "bulk collect into" in PL/SQL to get the records and return a "table of" type of variable from the function, how can I handle this in Java?
Thanks for the help in advance.