-
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!!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|