Corelab.Oracle.Oracleexception network error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Sebastian Wypiór
Posts: 1
Joined: Fri 24 Sep 2010 08:46

Corelab.Oracle.Oracleexception network error

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post Reply