Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error message : ORA-01000: Maximum number of open cursors reached ??

 
Harish Muthuraman
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When i tried to update the database after page submit, i got the error message "ORA-01000: Maximum number of open cursors reached".
what does this mean?
can any one help me??
 
Rene Larsen
Ranch Hand
Posts: 1179
Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you haven't closed your Statements, ResultSet and/or Connection i your code ??

Can you post the code which uses JDBC, and where you have the problem ??
 
Gus Spier
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle documentation is your friend ...

Error Message: ORA-01000 maximum open cursors exceeded
Error Cause:
A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.

Action:
Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.

 
swapnil kachave
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Harish Muthuraman wrote:When i tried to update the database after page submit, i got the error message "ORA-01000: Maximum number of open cursors reached".
what does this mean?
can any one help me??


This error occur because in program you not handled statement object properly. if ( no. of statement object open > size of open_cursor variable of Oracle ) then this error is occur. If your doing transaction management then try to close the statement object who firing select query to your database or increase size of open_cursor in oracle.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic