Home » SQL & PL/SQL » SQL & PL/SQL » how to avoid maximum open cursors exceeded (Oracle 10g,XP)
how to avoid maximum open cursors exceeded [message #405030] Tue, 26 May 2009 02:22 Go to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

How to avoid maximum open cursors exceeded .In my database open_cursor limit is 300 .
When i executing a procedure which works on recursive technology THIS ERROR OCCURS apart from increasing cursor variable
ALTER SYSTEM SET open_cursors=1500 scope=both;

is there any other programmatic method .

Thanks in Advance
Re: how to avoid maximum open cursors exceeded [message #405032 is a reply to message #405030] Tue, 26 May 2009 02:26 Go to previous message
bonker
Messages: 402
Registered: July 2005
Senior Member
Quote:
How to avoid maximum open cursors exceeded


By ensuring that all your application connecting to this database closes all its explicitly opened cursors.

[Updated on: Tue, 26 May 2009 02:28]

Report message to a moderator

Previous Topic: Error in updating column
Next Topic: TRUNCATE TABLE inside a package giving Compilation Error
Goto Forum:
  


Current Time: Sun Dec 04 12:35:57 CST 2016

Total time taken to generate the page: 0.09855 seconds