Found this: http://www.nabble.com/Statement-Caching-Question-td20437084.html
Hope it helps GL 2009/3/25 Daniel Sánchez Gómez <dsanc...@satec.es> > Hi, > > I have a problem with open cursors using Ibatis in an Oracle data base. > > When I open a transaction with a lot of querys and before the transaction > ends, an exception appears: “Too many cursors are open”. > > What can I do to resolve this problem? Is there any instruction to close > cursors without ending transaction? We can’t increase the number of cursors > in the database. > > Thanks! >