You are currently browsing the tag archive for the ‘ORA-01000 maximum open cursors exceeded’ tag.
You may hit ORA-01000 maximum open cursors exceeded in your daily life.
So what is a cursor? Why you are hitting this error? In this post let us see inside of this error.
Cursors in Oracle
A cursor is a temporary work area created in the system memory when a SQL statement is executed. It can hold more than one row but can process only one row at a time. A set of rows the cursor holds is called an active set. The cursor might be used for retrieving data on a row-by-row basis like a looping statement.
Helios's Blog 