CODEWITHSUNDEEP
oracle11gcursor
Cornelis
Cornelis

Reputation: 1107

Closing all open cursors

Question:

Is there a way to close all the cursors you are using in the database? To my knowledge one can only close a cursor one at a time or as a collective by association with tables using a FOR loop.

Reason behind question:

I have been getting the "maximum open cursors exceeded" when running SOME scripts for creating and populating tables in SQL Developer. I can usually run additional scripts after one has failed because of the error.

Upvotes: 0

Views: 814

Answers (1)

Swapnil Boralkar
Swapnil Boralkar

Reputation: 308

You may ask your Oracle DBA to increase open_cursors parameter at database level to solve your problem(This will require downtime).

Upvotes: 1

Related Questions