Updating board in oracle form
Is there anything like thread in Oracle forms for updating one part? I want to create a message box and update that part with the new events, so I need开发者_StackOverflow社区 to have something like thread or Timer in my oracle form. Any examples or ideas?
I am working with Oracle forms 6i, but I can convert to 10g also. My oracle server version is 9.
The help file/ online documentation in Oracle Forms features sample code on creating timers.
Create a timer, perhaps under WHEN-NEW-FORM-INSTANCE
trigger
DECLARE
timer_id timer;
begin
timer_id := CREATE_TIMER('TIMER1',20000,REPEAT);
end;
This will create a repeating timer which will fire every 20 seconds.
Now under WHEN-TIMER-EXPIRED
trigger write the timer expiration handler
declare
timer_id timer;
begin
-- code for updating the relevant field(s)
end;
精彩评论