oradirect3 (for 1.1) bug1 : cursors dont close

oradirect3 (for 1.1) bug1 : cursors dont close

Postby 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
)
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
expas
 
Posts: 14
Joined: Wed 11 May 2005 00:09

Postby 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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for Oracle