ORA-01000: maximum open cursors exceeded.

      3 Comments on ORA-01000: maximum open cursors exceeded.
0 Flares Twitter 0 Facebook 0 Google+ 0 LinkedIn 0 Buffer 0 Email 0 Filament.io 0 Flares ×

Each user session can open multiple cursors up to the limit set by the initialization parameter OPEN_CURSORS.
If the number of open cursors exceeds this limit,oracle will throw the ‘ORA-01000: maximum open cursors exceeded‘ exception or error.

ORA-01000: maximum open cursors exceeded.

To make sure that the number of open cursors doesn’t exceeds the limit as specified in initialization parameter, close the cursors after the use.

Read: Cursor | Oracle PL/SQL Cursors and example.

For example when we use a Cursor object or resultset object,close it once the operation is over.
When we use JDBC programming ,this error is common. This is because ,the application developer is either missed of not closed the jdbc object used.The objects can be Statements,Result sets or even JDBC database connection objects.

Also Read:

Technorati Tags:
, , , ,

0 Flares Twitter 0 Facebook 0 Google+ 0 LinkedIn 0 Buffer 0 Email 0 Filament.io 0 Flares ×

3 thoughts on “ORA-01000: maximum open cursors exceeded.

  1. Pingback: Oracle Cursors | OPEN ,FETCH and CLOSE Cursor statements. | SQL and PLSQL

  2. Pingback: Oracle CURSOR with parameter | SQL and PLSQL

Leave a Reply

Your email address will not be published. Required fields are marked *

Paged comment generated by AJAX Comment Page