Re: Timeout Question

From: Richard J Woodland <richwoodland_at_interfacefamily.com>
Date: Fri, 04 Sep 1998 16:01:32 -0400
Message-ID: <35F0471C.AF@interfacefamily.com>

John Lawson wrote:
>
> Can anyone help me ?
>
> ORACLE7 SQLForms3 UNIX ICLDRS6000
>
> I need to put a timeout in an ORACLE form to kick a user out after say
> 30 minutes idle time. I can do this if the user is on a UNIX command
> line, but not while the end-user is in an ORACLE form.
>
> INGRES can do it, PROGRESS can do it, but it seems that ORACLE can't.
>
> Any ideas folks ?
>
> john.lawson_at_east-ayrshire.gov.uk

Use the CREATE_TIMER service to create a timer that expires after (say) 1 minute. In the trigger for that timer, check a global counter (which is reset to a particular value, say 30, each time any button is pushed, field modified, whatever).

If expired, issue the EXIT_FORM routine to leave forms. Note that if the form is in query mode, you will need two EXIT_FORMs, one to leave query mode, one to leave the form. Of course, just put a pair of them, and it'll work every time!

A little clunky, but it does work.

Rich Woodland
Magic Interface, Ltd. Received on Fri Sep 04 1998 - 15:01:32 CDT