ORA-01000 maximum open cursors exceeded

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 Continue reading