本文介绍了Create_record oracle表单的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个多记录块,我想要的是在离开记录(向上或向下)后触发插入记录.

I have a multi-record block and what I wanted is to fire insert record after leaving a record (going up or down).

我试图将 create_record 放入 WHEN-VALIDATE-RECORD 中,但它说这是非法的受限程序.

I tried to put create_record in WHEN-VALIDATE-RECORD but it say that its an illegal restricted procedure.

如何在 何时验证记录 创建记录?我需要一个程序/计时器吗?请告诉我如何.谢谢!

How can I do create_record in WHEN-VALIDATE-RECORD? Do I need a procedure/timer? Please show me how. Thanks!

推荐答案

您可以使用WHEN-NEW-RECORD-INSTANCE触发器,其中使用内置的create_record不受限制的 ,在提到的多记录块级别而不是WHEN-VALIDATE-RECORD中使用受限的情况下.

You might use WHEN-NEW-RECORD-INSTANCE trigger, where using create_record built-in is not restricted , at that mentioned multiple-record block level instead of WHEN-VALIDATE-RECORD in which using is restricted.

这篇关于Create_record oracle表单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-26 15:53