I'm getting an Open Cursor exeeded error while running one of our web enabled application. The ASP is running some SQLs to display some pages. I increased the OPEN_CURSORS to 500, but still the error persists. platform: Oracle 817 on windows. I did some metalink search, but not very useful info to me. Any guidelines to address this issue?
- Also, when you open multiple cursors with the same name, remember to close each one after opening next one. Else it opens a new cursor, and leaves the previous cursor open.
- Also, close all open cursors in exception handler.
- Its safe to use a for loop to open cursor, as against a open ... fectch .. close.