Re: proC question - How to disconnect?

Andreas,

I'm at home and don't have access to the documentation, but I believe you can do the following to disconnect in a Pro*C program.

EXEC SQL COMMIT RELEASE; Jason Ford

To reply reverse the letters in my username.

On Thu, 13 Nov 1997 17:44:39 GMT, andreas_at_progis.de (Andreas Fassl) wrote:

>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
Received on Fri Nov 14 1997 - 00:00:00 CST