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