ORA-01000: maximum open cursors exceeded

Tags:
ORA
XML
I'm getting the ORA-01000: maximum open cursors exceeded in one XML. How do I resolve this? All result set and statements are closed in finally block.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

This occurs when a host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user. Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.
You can change the maximum number of cursors on Oracle using the following statement: ALTER SYSTEM SET OPEN_CURSORS=1337 SID=’*’ SCOPE=BOTH;

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    "All result set and statements are closed in finally block"

    Are you completely sure?

    That error is most of the times caused by result set/readers not being closed. 

    As the answer above mentions, there is a parameter about the maximum open cursors, but I have never seen this happening when applications are written correctly (unless the parameter is set to a really small value).

    Without looking at the code, it is hard to make more suggestions.
    85,055 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: