[ServletException in:/catalog/resultscategorysub.jsp] SQLException while getting category : SELECT CATEGORYID, CATEGORYNAME, DESCRIPTION, SEARCHKEYWORD, PARENTCATEGORYID, PICTUREURL, ANCESTORVALUE, USERDEFINE0, USERDEFINE1, USERDEFINE2, USERDEFINE3, USERDEFINE4, USERDEFINE5, USERDEFINE6, USERDEFINE7, USERDEFINE8, catalogtitle, catalogdescription, catalogkeyword, ANCESTOR, (SELECT count(CATEGORYID) from CATEGORY where PARENTCATEGORYID = 100) as childCount FROM CATEGORY WHERE CATEGORYID = 100 ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded '