Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
kaa4008
Post subject: ORA-01000: maximum open cursors exceeded  PostPosted: Aug 17, 2005 - 10:43 PM
Registered Member
Registered Member


Joined: Jun 29, 2004
Posts: 2

I'm getting a maximum open cursors exceeded message. It appears that a cursor is being created for each statement in the SQL editor that is executed and the cursor is not being closed. I created a simple SQL file that reproduces the bug. It looks as follows (note underscores added to make the screener happy):

drop_table_Widget;
create_table_Widget
(
id integer primary key
);
insert_into_Widget values ( 1);
insert_into_Widget values ( 2);
insert_into_Widget values ( 3);
....
insert_into_Widget values (298);
insert_into_Widget values (299);
insert_into_Widget values (300);

The Oracle open cursor value is set to 300. If I drop about 4 inserts then I don't get the message.

My configuration is:
Eclipse 3.0.2
MyEclipse 3.8.4
JDK 1.5.0_04-b05
Oracle 10g
Windows XP
I have also reproduced the bug under
Eclipse 3.1.0
MyEclipse 4.0m3
JDK 1.5.0_04-b05
Oracle 10g
Windows XP
Both of these configurations are clean installs.
 
 View user's profile Send private message  
Reply with quote Back to top
support-scott
Post subject:   PostPosted: Aug 19, 2005 - 03:32 PM
Moderator
Moderator


Joined: May 06, 2003
Posts: 6799

Thanks for reporting this. We've opened a bug report with the dev team to get this investigated / fixed for the next release.

_________________
--Scott
MyEclipse Support
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits