CODEWITHSUNDEEP
sqloracle-databasecursor
Cornelis
Cornelis

Reputation: 1107

Maximum Open Cursors Exceeded In SQL developer

I am using SQL Devolopper and I am getting the Max open cursors exceeded. I tried to look it up aswell as solutions but I can't seem to understand it. Can someone please explain to me in detail what the problem is and how it is fixed.

Upvotes: 1

Views: 1239

Answers (1)

Swapnil Boralkar
Swapnil Boralkar

Reputation: 308

Please try to close cursors in PL/SQL before you open more cursors. There is limit defined at database level for number of open cursors in the database ( Parameter open_cursor). You may ask your Oracle DBA to increase open_cursor parameter at database level( This will require downtime).

Upvotes: 1

Related Questions