File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes implicit open cursors problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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:
subject: implicit open cursors problem
It's not a secret anymore!