when_timer_expired [message #80612] |
Mon, 21 October 2002 02:23 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
daisy
Messages: 4 Registered: May 2002
|
Junior Member |
|
|
When ý wrote when_timer_expired_trigger
declare
begin
update CUSTOMER_FORMS SET STATUS=3 WHERE CUSTOMER_NUMBER = 4;
end;
This code is not working.Why????
|
|
|
Re: when_timer_expired [message #80614 is a reply to message #80612] |
Mon, 21 October 2002 08:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Julie
Messages: 98 Registered: February 2002
|
Member |
|
|
I think you need to determine if the trigger is firing by putting a message in it. If it does truly fire, there is no reason it wouldn't work, unless your condition is not met.
|
|
|
|