Corelab.Oracle.Oracleexception network error

Corelab.Oracle.Oracleexception network error

Postby Sebastian Wypiór » Fri 24 Sep 2010 10:19

Hi,

I found that when my MC3090 wakes up after power off, my Oracle.ConnectionState is Open which is not true. That situation causes problem because when I try to execute some SP I'm getting Oracle Network Exception.

Is there some way to handle this problem ?

My CoreLab.Oracle.dll version is 4.70.38.1

regards
Sebastian Wypiór
 
Posts: 1
Joined: Fri 24 Sep 2010 08:46

Postby Shalex » Tue 28 Sep 2010 17:12

The OracleConnection.Ping() method is implemented in the current version of dotConnect for Oracle. It can be used to check if connection is valid before using it.

If your version doesn't include implementation of this method, try executing some test query (e.g., "begin null; end;") to check your connection object.
Shalex
Devart Team
 
Posts: 7344
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle