This occurs when a host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user. Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.
You can change the maximum number of cursors on Oracle using the following statement: ALTER SYSTEM SET OPEN_CURSORS=1337 SID=’*’ SCOPE=BOTH;