• Post Reply Bookmark Topic Watch Topic
  • New Topic

implicit open cursors problem  RSS feed

Vijay Vishwanath
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!