I am connecting to a new database run by another company and have been experiencing an intermittent error: [Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded When I talked to the DBA's who maintain the database they told me: If your app is erroring out with the "max opened cursors exceeded" error, then its usually an indicator that your app is not explicity closing all cursors that it is opening. Each insert or select sequence statement would be an implicit cursor in Oracle. Coldfusion should close the cursors. Anyone know how to go about this? I worked with Oracle about 3 years ago regularly and don't remember this ever coming up? Is this possibly version dependent? Thanks, Scott
--- [This E-mail scanned for viruses by Declude Virus] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192028 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
