Sunday, 28 February 2016

How to use the Timer in oracle Forms 6i / 10g / 11g

How to create digital clock in Oracle Forms


Timer in Oracle Forms is very easy to use you have only to  write a two Triggers

1.     WHEN-NEW-FORM-INSTANCE
2.     WHERE-TIMER-EXPIRE

======================
WHEN-NEW-FORM-INSTANCE

Declare
       timer1 timer;
Begin
--Create a timer to trigger it every 1 sec(1000msec)
timer1:=create_timer('timer1',1000,repeat);
END;

====================

WHERE-TIMER-EXPIRE

:DISPLAY_ITEM4 := to_char(sysdate,'hh24:mi:ss');

3 comments:

  1. Hi... can you please tell me how to do the same process for reverse time

    ReplyDelete
  2. how i can make this timer like stopwatch

    ReplyDelete