Oracle Connection Timeout

Oracle Connection Timeout

Postby scott.pedersen » Mon 14 Aug 2006 04:51

Hi,

I am running a stored procedure that is called using OraDirect and after about 30 seconds the connection times out.

Is there a way that I can specify a longer timeout period? I am using the OracleConnection class that doesn't allow the changing of the ConnectionTimout.

Cheers,

Scott.
scott.pedersen
 
Posts: 21
Joined: Tue 06 Jun 2006 03:14
Location: Auckland, New Zealand

Postby Paul » Mon 14 Aug 2006 06:49

This problem can happen if Direct=true only. You can set OracleCommand1.CommandTimeout=0 for specifying no limit to the wait time.
See DbCommandBase.CommandTimeout Property in Oradirect .NET documentation.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle