Error Message: ORA-01000 maximum open cursors exceeded
A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.
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.
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 ??