Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

close alert-window automatically

125461Dec 19 2001 — edited May 5 2008
Hi all,
the problem:
I want to ask users after some minutes of inactivity if they
want to close the application or continue working.
Therefore I start a Timer wich displays an alert-window
(yes-no)!
If the user clicks a button it works but what if the user
ignores the alert becuase he/she is out of office!
Because of the modality of the alert window, the 2nd timer
doesn't fire the expired event!
here's the code:
WHEN_TIMER_EXPIRED TRIGGER

DECLARE
expired_timer CHAR(20);
BEGIN
expired_timer:=GET_APPLICATION_PROPERTY(TIMER_NAME);
IF expired_timer='T1'
THEN
p_show_passive_alert;
ELSIF expired_timer='T2'
THEN
logout;
END IF;
END;


The procedure p_show_passiv_alert
the code after v_button := .... is never reached
PROCEDURE p_show_passive_alert IS
v_button VARCHAR2(20);
T2 TIMER;
BEGIN
T2 := find_timer('T2');
if not id_null(T2) then
delete_timer(T2);
end if;
T2 := create_timer('T2',10000,repeat);
v_button := fp_alert.multi_button('Yes_No','close or
continue');
IF v_button = 'YES' THEN
SHOW_WINDOW('TABLES');
delete_timer(T2);
ELSIF v_button = 'NO' THEN
EXIT_FORM(NO_VALIDATE);
END IF;
END;



thanx a lot for your help
joe
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2008
Added on Dec 19 2001
2 comments
1,101 views