Quote:
Originally Posted by ali_hammad
I know why this exception is generated,  but I can not go through all the code and figure out where the connections, statements and resultsets are not properly closed because I had been given a task to figure out some one else's problem  and the code is composed of 736  jsp and couple of hundred servlets  , so it is almost impossible to go through all the statements..
Please tell me some trick or tip by which i could fix this bug with minimum navigation....
your help will be greatly appreciated... |
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