Member Avatar for Majestics

ORA-01000: maximum open cursors exceeded tips

I am getting following error.
I made a combo box with select query behind it, i used itemlistener to fetch data. Today during testing i found that if user move too quickly in combo box so select query will be fired for each number he passes and it gives an error. So what does it mean and how to resolve it... Thank you in advance.

  • 3 Contributors
  • 2 Replies
  • 174 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by shapam
Member Avatar for babyDBA

Connect to the database as SYS and execute this query

ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;

or

set in the init.ora file parameter open_cursors, for example

open_cursors=400

and restart database

instead of 400 set as you want

Member Avatar for shapam

actually default open_cursors are set to 300 in oracle database so you can change it to how much open_cursors you want so try the following query
sql>alter system set open_cursors=500 scope=BOTH(as your wish how much open_cursors you want you just specify next to open_cursors column)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.