oradirect3 (for 1.1) bug1 : cursors dont close

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 14
Joined: Wed 11 May 2005 00:09

oradirect3 (for 1.1) bug1 : cursors dont close

Post by expas » Tue 14 Jun 2005 04:05

we have proc on Oracle (with ~30 cursor open at one time limit):

Code: Select all

create or replace procedure test_close_of_cursor
cur out MyTypeRefCorsor
	open cur for
		select * from dual;
end test_close_of_cursor;
and we use it proc in our dotNet app:

Code: Select all

for (int i=0; i<1000; i++)
	using(OracleCommand cmd = new OracleCommand("test_close_of_cursor", (OracleConnection)_cnn))
		cmd.CommandType = CommandType.StoredProcedure;
		OracleParameter p = new OracleParameter("cur", OracleDbType.Cursor);
		p.Direction = ParameterDirection.Output;
		using (OracleDataReader reader = cmd.ExecuteReader())
on ~30 iteration we receive ORA-01000: Maximum open cursors exceeded

so - cursors dont close even after dispose of command and reader

Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Post by Oleg » Fri 17 Jun 2005 13:23

We reproduced your problems and now we are working on solving them.
These fixes will be included in the next build that will be in a week.
Please see announcements at the forum to get know when a new build is released.

Post Reply