This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell 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


JavaRanch » Java Forums » Databases » JDBC
Bookmark "implicit open cursors problem" Watch "implicit open cursors problem" New topic
Author

implicit open cursors problem

Vijay Vishwanath
Greenhorn

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 ]
 
GeeCON Prague 2014
 
subject: implicit open cursors problem