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!

How to stop a timer?

684380Jul 28 2011 — edited Jul 28 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2011
Added on Jul 28 2011
2 comments
1,319 views