 |
|
|
 |
|
 |
|
| Author |
Message |
|
|
Post subject: ORA-01000: maximum open cursors exceeded
 Posted: Aug 17, 2005 - 10:43 PM
|
|
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. |
|
|
| |
|
|
|
 |
|
|
|
Post subject:
Posted: Aug 19, 2005 - 03:32 PM
|
|
Moderator
Joined: May 06, 2003
Posts: 6598
|
|
| 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
|
| |
|
|
|
|
|
|
| |
|
|
 |
|
 |
|
|
|
|
Search
Register
Log in to check your private messages
