MyEclipse :: View topic - ORA-01000: maximum open cursors exceeded

MyEclipse: ORA-01000: maximum open cursors exceeded

kaa4008 - Aug 17, 2005 - 10:43 PM
Post subject: ORA-01000: maximum open cursors exceeded

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.

support-scott - Aug 19, 2005 - 03:32 PM
Post subject:

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