ORA-00604 & ORA-01000 Error , Help Please! [message #18832] |
Sun, 17 February 2002 21:56 |
msfeline
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
I encountered this error when trying to alter my unit_dir table
SQL> alter table unit_dir modify
2 (TEL_NO VARCHAR2(8));
alter table unit_dir modify
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
Can someone help me..
|
|
|
Re: ORA-00604 & ORA-01000 Error , Help Please! [message #18836 is a reply to message #18832] |
Mon, 18 February 2002 01:47 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
ORA-01000 maximum open cursors exceeded
------------------------------------------------
Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.
Action: 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.
|
|
|