ExecuteNonQuery hangs for simple UPDATE
Posted: Fri 08 Jun 2012 15:03
I am currently evaluating dotConnect for Oracle and have encountered the following problem.
I create an OracleCommand for an update and call ExecuteNonQuery and the call does not return. The command text is:
I am using v7.0.6.0 of the Devart.Data.Oracle DLL, downloaded only days ago. Using Direct mode for the connection to the database. This update is performed correctly in the Oracle SQL Developer environment.
The call stack suggests a problem receiving a response from the database server, but other updates have worked without encountering this problem:
I create an OracleCommand for an update and call ExecuteNonQuery and the call does not return. The command text is:
Code: Select all
UPDATE SystemUser SET LastLogin = TIMESTAMP '2012-06-08 15:55:24' WHERE ID = 1The call stack suggests a problem receiving a response from the database server, but other updates have worked without encountering this problem:
Code: Select all
[Managed to Native Transition]
System.dll!System.Net.Sockets.Socket.Receive(byte[] buffer = {byte[4096]}, int offset = 0, int size, System.Net.Sockets.SocketFlags socketFlags = None, out System.Net.Sockets.SocketError errorCode = Success) + 0xc6 bytes
System.dll!System.Net.Sockets.Socket.Receive(byte[] buffer, int offset, int size, System.Net.Sockets.SocketFlags socketFlags) + 0x20 bytes
System.dll!System.Net.Sockets.NetworkStream.Read(byte[] buffer, int offset, int size) + 0x87 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.c2.a(byte[] A_0 = {byte[4096]}, int A_1 = 0, int A_2 = 8) + 0x89 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.c2.a(out byte A_0 = 0) + 0x38 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.cw.b(byte[] A_0 = {byte[1]}, int A_1 = 0, int A_2 = 1) + 0xd1 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.cw.f() + 0x56 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.bn.n() + 0x25 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.ar.c() + 0x106 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.ab.a(int A_0 = 1, Devart.Data.Oracle.bx A_1 = f) + 0xd00 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.InternalExecute(System.Data.CommandBehavior behavior = Default, System.IDisposable disposable = {Devart.Data.Oracle.ab}, int startRecord = 0, int maxRecords = 0, bool nonQuery = true) + 0x790 bytes
Devart.Data.dll!Devart.Common.DbCommandBase.ExecuteDbDataReader(System.Data.CommandBehavior behavior = Default, bool nonQuery = true) + 0x153 bytes
Devart.Data.Oracle.dll!Devart.Data.Oracle.OracleCommand.ExecuteNonQuery() + 0x4c bytes
DIPCOR00.dll!DIP.Security.Users.DiUser.UpdateLastLogin(int iUserID = 1, System.DateTime dtmLoginDateTime = {System.DateTime}, DIP.Data.DiDataWrapper dwConnection = {DIP.Data.DiOracleDataWrapper}) Line 3486 + 0x9 bytes