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 Murach's Java Servlets and JSP this week in the Servlets 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 ]
I agree. Here's the link: http://aspose.com/file-tools
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