Hi People,
I use forms 6i and oracle 10g.This is the first time i am using TIMER in my application.I created a timer in WHEN-BUTTON-PRESSED trigger as follows,
DECLARE
v_timer TIMER;
BEGIN
v_timer := CREATE_TIMER('alarm', 1, REPEAT);
END;
also written code in WHEN-TIMER-EXPIRED as follows,
declare
begin
insert into xx values(888,999);
commit;
end;
which is written at form level.now my issue is timer is working constantly but how to stop this timer now.records are being inserted continuously in my table XX.I tried disconnectiong my session but even then i am unable to stop it.pls help me with required suggestions
Reg
Vids