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.