This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I am using Stored procedures heavily my application. What I could find out is that implicit cursors opened by stored procedures are kept open, even after we close the connection and statment. So whenever a procedure is called, the statments opened are left open in Session in Oracle. This is leading to SQLException because database is having a maximum limit for the number of open cursors it can allow. I'm using Oracle 10g database.
Please help me overcome this open cursor problem. Thanks in advance. [ May 06, 2007: Message edited by: Vijay Vishwanath ]