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

Thread: cursor error!!

  1. #1
    Join Date
    Mar 2001
    Posts
    1
    Line: 1 Column: 1 Error: ORA-00604: error occurred at recursive SQL level 1
    ORA-01000: maximum open cursors exceeded

    I am getting this weird error.. I don't have recursive loop in my procedure..I jus have 1 cursor.. I open it , fetch it nd close it at the end.. I don't know what's do be done!!

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    Yu must be using Java and many developers relly forget to close the Cursors that have been defined in Parameter File.

    Ask your DBA to Increase the Number of Open Cursors in the Initialization Parameter File and you will be on the safe side. If you are alos using JAVA Try to close the cursor that you are getting from ORacle.

    Hope this help...
    Thanks

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