2 Replies Latest reply: Aug 26, 2013 7:13 AM by Elad RSS

    Avoid from the error message: "FRM-41816: Attempt to create existing timer"

    Elad

      Hi,
      I create a timer in "on-insert" trigger in data-block level, like this:
      timer_id := Create_Timer ('saving_inserting_timer' , 1 , NO_REPEAT);

      in the trigger "when-timer-expired" in form level,  I use this timer, like this: 
      timer_id := FIND_TIMER('saving_inserting_timer');

      I know  that I should write:
      DELETE_TIMER('saving_inserting_timer');
      to avoid the error message frm-41816, and I tried to  write this line in a several places in the code (in both triggers).  But I still get this error message.

      Thanks in advanced,
      Elad