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 ]