All errors › ORA errors
ORA-01000: Maximum open cursors exceeded
What it means
A session has more open cursors than the OPEN_CURSORS parameter allows. Almost always a leak: application code that does not close ResultSet/Statement objects, or PL/SQL that opens explicit cursors / ref cursors in a loop without closing them.
How to fix it
Close statements and result sets in finally / try-with-resources, close explicit and REF cursors in PL/SQL (also in the exception handler). Find the leaking SQL with v$open_cursor for the session. Raising OPEN_CURSORS only hides a leak.
Catch it before it runs
ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Nearby errors
Updated 2026-11-12.