How to Use timer on oracle??
1. Create XTIMER procedure on program unit as below :PROCEDURE XTIMER IS2. Create WHEN-NEW-FORM-INSTANCE trigger on the form level
timer_id TIMER;
timer_interval NUMBER := 1000;
BEGIN
timer_id := CREATE_TIMER(‘timerq’,timer_interval,REPEAT);
END;
3. Put XTIMER; procedure on WHEN-NEW-FORM-INSTANCE
4. Create WHEN-TIME-EXPIRED trigger on the form level too
(Put PLSQL function here to execute PLSQL functions when time has expired)
Descriptions :
On the “time_interval NUMBER :=1000;”
1000 as like as 1 second around
parameters property :
timer name
timer time
timer process
on “timer process” has 2 parameters :
REPEAT and NO_REPEAT
