Home » SQL & PL/SQL » SQL & PL/SQL » maximum open cursers exceeded
maximum open cursers exceeded [message #223040] Wed, 07 March 2007 05:39 Go to next message
sachdeva_noor
Messages: 6
Registered: February 2007
Junior Member
hi !


I m working on a pro c code.


while running this code ,at one place i am getting an oracle error which saya "Maximum open cursers exceeded".

But the place at which i get this error, no other curser is open.there are many cursers i am using but all are closed before that.
can you suggest me something to solve this problem.

thanks.
Re: maximum open cursers exceeded [message #223047 is a reply to message #223040] Wed, 07 March 2007 06:09 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
what is the output of the following:

show parameter open_cursors
Re: maximum open cursers exceeded [message #223065 is a reply to message #223040] Wed, 07 March 2007 07:45 Go to previous messageGo to next message
raj_2005
Messages: 5
Registered: February 2006
Location: Pune
Junior Member
Hi there,

you can try to use cursor attribute is_open then close.


It may help you .

Regards,
Raj

Re: maximum open cursers exceeded [message #223072 is a reply to message #223065] Wed, 07 March 2007 07:58 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Very often the error message mentioned has nothing to do with cursors that are explicitly opened in your code. More often it deals with implicit (system) cursors.
Martijn is right: check your max_open_cursors parameter and increase it.

[Updated on: Wed, 07 March 2007 07:59]

Report message to a moderator

Previous Topic: urgent pls help me in this query
Next Topic: ORA-00904 Error in Table Function
Goto Forum:
  


Current Time: Sun Dec 04 02:15:32 CST 2016

Total time taken to generate the page: 0.03387 seconds