Possible complications for not closing database cursors?

What are the possible complications and repercussions if you do not close cursors for your Ora开发者_Python百科cle database?

Since your developers are complaining about the performance hit of repeatedly re-opening cursors, the proper solution in the database would be to close them in your code but set the session_cached_cursors parameter so that the database maintained a cache of the session's recently used cursors. Having them not close their cursors is going to cause the ORA-01000 error that you're seeing and will waste other server resources.