Home » Developer & Programmer » Forms » Timer have problem (oracle 9i, Forms 6i)
Timer have problem [message #399386] Tue, 21 April 2009 23:09 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi,
I have created a timer in when - new - form - instance

DECLARE
 Currtime timeR;
 OneSecond   CONSTANT NUMBER := 1000;
BEGIN
 Currtime := CREATE_timeR('CURRtime',OneSecond,REPEAT);
END;


and also when - timer - expired too.

Declare
	  mg varchar2(4000);
	  Dummy_var Number;
Begin
	  Select Msg into mg 
	    From Timer_Alert;
	  Set_Alert_Property('Talt',Alert_message_text,mg);
	  Dummy_var := Show_alert('Talt');	   
Exception
	  When No_Data_Found Then
	     Null;
End;


but i did received alert on that screen even i have a row in timer_alert table. what is the problem. please guide me.

kanish
Re: Timer have problem [message #399388 is a reply to message #399386] Tue, 21 April 2009 23:24 Go to previous message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Sorry it is working fine Thanks all.

kanish
Previous Topic: Right click on Hierarchical tree
Next Topic: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF
Goto Forum:
  


Current Time: Tue Dec 06 12:38:00 CST 2016

Total time taken to generate the page: 0.09859 seconds