On Jul 10, 3:35 pm, markus.doerschm..._at_gmail.com wrote:
> Hi,
>
> I'm using Embedded SQL to access an Oracle 10g database. My service
> opens one connection at start. Is there a more or less good way to
> check, if the connection is broken before sending/executing a SQL-
> statement? I'm using Pro*C and C (not C++ !!!!)
>
> thx
>
> Markus
Why? Want to make your program dead slow? Oracle usually doesn't break
connection, and if it does break connections it either does so because
the client (you) is doing nothing or because there is an exception.
You'd better concentrate on trapping exceptions properly, instead of
implementing redundant kludges from the start.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jul 10 2007 - 08:57:25 CDT
