Oracle/PLSQL: ORA-01000 Error

Error:

ORA-01000: maximum open cursors exceeded

Cause:

You tried to open too many cursors at once. Each user is restricted to the number of cursors open based on the OPEN_CURSORS parameter in the initialization file.

Action:

The options to resolve this Oracle error are:

Try to close cursors that you are no longer using before opening new cursors.
You may need to shut down Oracle, increase the OPEN_CURSORS parameter in the initialization file, and restart Oracle.