| Author |
Error message : ORA-01000: Maximum number of open cursors reached ??
|
Harish Muthuraman
Greenhorn
Joined: Jun 10, 2010
Posts: 11
|
|
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?? 
|
With Regards
Harish M
|
 |
Rene Larsen
Ranch Hand
Joined: Oct 12, 2001
Posts: 1179
|
|
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 ??
|
Regards, Rene Larsen
Dropbox Invite
|
|
Gus Spier
Greenhorn
Joined: Dec 27, 2007
Posts: 5
|
|
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
Joined: Feb 10, 2010
Posts: 27
|
|
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.
|
|
 |
|
|
subject: Error message : ORA-01000: Maximum number of open cursors reached ??
|
|
|
0
