• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
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??
 
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 ??
 
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.

 
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
Boost this thread!