proC question - How to disconnect?

From: Andreas Fassl <andreas_at_progis.de>
Date: 1997/11/13
Message-ID: <EJLIMG.DIK@progis.de>#1/1

Hi,

I'm looking how to disconnect from oracle in a running eSQL-program and reconnect later.
Reason: The program is running as a detached process (OpenVMS) and is

        supposed to stay in the system unattended for a long time
	(10 years?). The process has to check some tables for new
	entries once a day. 
	The cycle I would like to implement:


	- Wakeup

	- Connect to ORACLE

	- Check

	- Disconnect

	- Hibernate

At SQL/PLUS level I can enter a DISCONNECT statement, but it doesn't exist for proC. Has some one got an idea how to?

Regards

Andreas Fassl

-- 
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ proGIS Softwareentwicklung, Simulationssysteme, Beratung   + 
+ E-Mail: andreas_at_progis.de        VOICE:(49) 241 470 67 -0  +
+				   FAX:  (49) 241 470 67 -29 +

Received on Thu Nov 13 1997 - 00:00:00 CST