Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00604 & ORA-01000 Error , Help Please!
ORA-00604 & ORA-01000 Error , Help Please! [message #18832] Sun, 17 February 2002 21:56 Go to next message
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 Go to previous message
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.
Previous Topic: Force Index
Next Topic: Convert number in milliseconds to date
Goto Forum:
  


Current Time: Thu Mar 28 03:48:25 CDT 2024