oradirect3 (for 1.1) bug1 : cursors dont close
Posted: Tue 14 Jun 2005 04:05
we have proc on Oracle (with ~30 cursor open at one time limit):
and we use it proc in our dotNet app:
on ~30 iteration we receive ORA-01000: Maximum open cursors exceeded
so - cursors dont close even after dispose of command and reader
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;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())
{
}
}
}
so - cursors dont close even after dispose of command and reader