以Oracle形式更新板 [英] Updating board in oracle form

查看:88
本文介绍了以Oracle形式更新板的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

Oracle表单中是否有类似线程的内容可用于更新一部分?我想创建一个消息框并用新事件更新该部分,因此我需要在Oracle表单中使用线程或Timer之类的东西.有任何例子或想法吗?

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 to have something like thread or Timer in my oracle form. Any examples or ideas?

我正在使用Oracle Form 6i,但我也可以转换为10g.我的oracle服务器版本是9.

I am working with Oracle forms 6i, but I can convert to 10g also. My oracle server version is 9.

推荐答案

Oracle Forms中的帮助文件/在线文档提供了创建计时器的示例代码.

The help file/ online documentation in Oracle Forms features sample code on creating timers.

创建一个计时器,可能在WHEN-NEW-FORM-INSTANCE触发器下

Create a timer, perhaps under WHEN-NEW-FORM-INSTANCE trigger

DECLARE
    timer_id timer;
begin
    timer_id := CREATE_TIMER('TIMER1',20000,REPEAT);
end;

这将创建一个重复计时器,每20秒触发一次.

This will create a repeating timer which will fire every 20 seconds.

现在在WHEN-TIMER-EXPIRED触发器下,编写计时器到期处理程序

Now under WHEN-TIMER-EXPIRED trigger write the timer expiration handler

declare 
     timer_id timer;

begin
     -- code for updating the relevant field(s) 
end;

这篇关于以Oracle形式更新板的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆