Bug in oradirect with work expensive sql statements

Bug in oradirect with work expensive sql statements

Postby nerVouz » Tue 16 Aug 2005 12:26


our team has updated oradirect to version because we wanted to use the direct connetion mode (without using any oracle client).
Now, we've figured out some troubles with expensive sql statements in the direct mode.

If we execute the same query in indirect mode it takes a long time to get the result (which is not that big (less than 50 rows)). But it works fine in this mode.

If we want to do the same query in direct mode, we get an unhandled exception.
Code: Select all
'CoreLab.Oracle.OracleException' in system.data.dll
additional information: NET: Network error (System.Net.Sockets.SocketException
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size))
'CoreLab.Oracle.OracleException' in corelab.oracle.dll
additional information: NET: Network error 200

thx for helping.

so long,

p.s. changing the "connection timeout" paramter to higher or lower values did't take any effects.
Posts: 2
Joined: Fri 15 Jul 2005 04:55

Postby Paul » Wed 17 Aug 2005 08:25

Please change the value of OracleCommand.CommandTimeout. The default value is 30.
ConnectionTimeout works during the time of connection to Oracle server.
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Return to dotConnect for Oracle