I have a form that runs continuously in the background reading a table on the database at regular intervals and sending an email for each record that is found.

At present the form is closed down prior to bringing the database down for backup purposes, and restarted again after the database has been brought back up. This is done overnight via NT Scheduler. If the database crashes the form has to be manually stopped and started.

I've tried to get the form to re-logon automatically but get the error FRM-40029: Already logged on. I've placed the Logout built-in before the Logon but this doesn't seem to help.

The form can log itself back on if the session is killed, but fails when the database is bounced.

Can you help please?

Database is Oracle8i Enterprise Edition Release 8.1.6.0.0
JServer Release 8.1.6.0.0

For info, the basic code is as follows:
When-New-Form-Instance Trigger
:global.username := Get_Application_Property(USERNAME);
:global.password := Get_Application_Property(PASSWORD);
:global.connect_string := Get_Application_Property(CONNECT_STRING);

When-Timer-Expired Trigger (every ten seconds)
begin
select sysdate into :GLOBAL.dummy from dual;
exception
when others then
logout; -- in case session still thought to be logged on !!
logon(:global.username, :global.password||'@'||:global.connect_string, false);
end;