oradirect3 (for 1.1) bug1 : cursors dont close

[expas]

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
)
is
begin
	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;
		cmd.Parameters.Add(p);
		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

[Oleg]

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.