Exception in CoreLab.Oracle.OracleCursor.Finalize()

Exception in CoreLab.Oracle.OracleCursor.Finalize()

Postby Leonid » Sun 10 Dec 2006 17:14

We are using OraDirect .NET 3.50.10 in our .Net application and Oracle 9.2.0.4. .Net code that works with Oracle DB is state inside .DLL that we are calling through another .EXE. We are working in Direct mode and Unicode = true. We reading output cursors by OracleDataReader. Sometimes on closing application I am recieving error:
System.ObjectDisposedException was unhandled
Message="Safe handle has been closed"
Source="System"
ObjectName=""
StackTrace:
at System.Net.UnsafeNclNativeMethods.OSSOCK.getsockopt(SafeCloseSocket socketHandle, SocketOptionLevel optionLevel, SocketOptionName optionName, Int32& optionValue, Int32& optionLength)
at System.Net.Sockets.Socket.GetSocketOption(SocketOptionLevel optionLevel, SocketOptionName optionName)
at System.Net.Sockets.TcpClient.numericOption(SocketOptionLevel optionLevel, SocketOptionName optionName)
at System.Net.Sockets.TcpClient.get_ReceiveTimeout()
at CoreLab.Oracle.g.a(Int32 A_0)
at CoreLab.Oracle.b.a()
at CoreLab.Oracle.a5.q()
at CoreLab.Oracle.OracleCursor.Finalize()


The problem occurs occationally and hard reprodusable. Do you have any idea what is the reason of this exception?
Leonid
 
Posts: 24
Joined: Wed 26 Oct 2005 12:59

Postby Leonid » Mon 11 Dec 2006 07:40

Some details: reading output stored procedure cursors implemented like this:
GlobalData.DataBaseAccess.oraConnection.Open();
GlobalData.DataBaseAccess.getDescriptiveCommand.ExecuteNonQuery();
CoreLab.Oracle.OracleDataReader dataReader =
((OracleCursor)getDescriptiveCommand.Parameters ["cursorName"].OracleValue).GetDataReader();
while (dataReader.Read())
{
}
dataReader.Close();

May be the problem is somewhere here? When I am commenting this code the exception is disappear.
Leonid
 
Posts: 24
Joined: Wed 26 Oct 2005 12:59

Postby Alexey » Mon 11 Dec 2006 08:05

We are investigating this problem.
You will be notified on results as soon as possible.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Mon 18 Dec 2006 08:08

This problem is fixed in OraDirect 3.55.15.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Leonid » Mon 18 Dec 2006 10:57

Hi,
Can you please tell me when the version 3.55.15. is expected?
It is very urgent to us.
Thanks
Leonid
Leonid
 
Posts: 24
Joined: Wed 26 Oct 2005 12:59

Postby Alexey » Mon 18 Dec 2006 11:12

OraDirect .NET Data Provider 3.55.15 has already been released.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Leonid » Mon 18 Dec 2006 13:06

Thank you. Very good job!
Leonid
 
Posts: 24
Joined: Wed 26 Oct 2005 12:59

Postby Alexey » Tue 19 Dec 2006 07:40

You're welcome.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle