DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Max. Cursor

  1. #1
    Join Date
    Oct 2000
    Posts
    123
    Does anybody experience the problem:
    at "abc_proc"(procedure name), line 28
    ORA-01000: maximum open cursors exceeded.
    ORACLE 8i.

    I have run this process successfully all the time before last week. But it occurs this error message every time when I run the same process right now. My maximum cursor open allowance is 350 in init.ora file. Basically, the process is two nested loop and some procedure calls as well as some update statements. Don't tell me rewrite the procedure or increase the max. cursor, because I can run the same procedure successfully before, and I didn't change anything later.

    Appreciate for any help.

    Thanks

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Issue
    ALTER SYSTEM FLUSH SHARED_POOL;

    And then run the procedure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width