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

Return to dotConnect for Oracle