This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes implicit open cursors problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "implicit open cursors problem" Watch "implicit open cursors problem" New topic

implicit open cursors problem

Vijay Vishwanath

Joined: Apr 18, 2007
Posts: 7
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 ]
wood burning stoves
subject: implicit open cursors problem
Similar Threads
large resultset connection times out
too many open cursors
Is it possible that number of open_cursors raise above maximum set limit
Calling database stored procedures using EJB
Q about JDBC driver classes: how many open cursors