CURSORS ?????
Posted: Tue 23 Aug 2005 21:51
i already post this bug (you fix blob and number but what about cursors?)
we test last version and find that CURSORS DONT CLOSE!!!!!!!!!!!!
SQL code:
C# code:
it generate error ORA-01000 and ORA-06512
pls, answer, do you plan to fix this? or may be need to write some specific code to close corsor?
we test last version and find that CURSORS DONT CLOSE!!!!!!!!!!!!
SQL code:
Code: Select all
create or replace package mypkg
is
type refCur is ref cursor;
end mypkg;
create or replace procedure test_close_of_cursor
(
cur out mypkg.refCur
)
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())
{
}
}
}pls, answer, do you plan to fix this? or may be need to write some specific code to close corsor?