Forum OpenACS Q&A: Response to ORA-01000: maximum open cursors exceeded ??

Posted by Don Baccus on
At least the Oracle documentation claims an error would be thrown!  In
aD's defense I'll point out that I found two conflicting examples in the Oracle documentation on explicit cursors, one which closes the cursor after a NOTFOUND condition was raised and one which doesn't.

Since explicit closing doesn't throw an error we should ferret out these cases and do the close.

Andrew - would you have time to make these changes to your local instance of ACS 4.2 Classic and let us know if doing so causes your cursor leak problem to go away?