Bug in oradirect with work expensive sql statements

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 2
Joined: Fri 15 Jul 2005 04:55

Bug in oradirect with work expensive sql statements

Post by 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: 725
Joined: Thu 28 Oct 2004 14:06

Post by 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.

Post Reply