If is a user process connected to the database?

From: Alex Vinokur <alexander.vinokur_at_telrad.co.il>
Date: Tue, 23 Nov 1999 08:27:00 GMT
Message-ID: <81dj4h$f9o$1@nnrp1.deja.com>

Hi,

1. How can we know in Pro*C/C++ if a user process is connected to the database? P.S. I have got ORA-01012: not logged on
2. Here is a piece from Oracle8 Documentation.

//===============================
//-------------------------------

Oracle8 Error Messages
Release 8.0.4
A58312-01

<quote>

ORA-01012: not logged on

<snip>

       after the instance it is connected to terminates,
       forcing the process to disconnect.

<snip>

</quote>

//===============================

What does it mean : ... connected to terminates? Why (and when) does it happen?

//#########################################################
//------------------- Environment -------------------------

=== Oracle 8.0.5

=== Pro*C/C++ : Release 8.0.5.0.0
=== SunOS 5.6

//---------------------------------------------------------

//#########################################################


        Thanks in advance,
        Alex

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 23 1999 - 02:27:00 CST