ANY answer.
Re: ORA-01000: maximum open cursors exceeded
Answer:
Cause : A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursor per user.
Action:
Modify the program to use fewer cursors. if this errors occur offen ,shutdown Oracle,increase the value of OPEN_CURSORS, and then restarted Oracle
|