implicit open cursors problem

[Vijay Vishwanath]

Hello everyone,

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 ]