View Single Post
  #3 (permalink)  
Old 08-02-2007, 03:22 PM
BOOPATHI
 
Posts: n/a
Default 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
Reply With Quote