使用PLSQL更新Apex表格形式 [英] Update Apex Tabular form with PLSQL

问题描述

如何使用pl/sql而不是使用多行更新(MRU)更新Apex表格形式，甚至有可能吗?

How can I update an Apex Tabular Form with pl/sql instead of using a multi-row update(MRU), is it even possible?

谢谢.

推荐答案

是的，有可能.您可以删除(或禁用)诸如ApplyMRU之类的标准进程，并用您自己的PL/SQL进程替换它们，以处理表格形式的数组，如下所示:

Yes, it is possible. You can delete (or disable) the standard processes such as ApplyMRU, and replace them with your own PL/SQL processes to handle the tabular form arrays something like this:

for i in 1..apex_application.g_f02.count loop
   update dept
   set    dname = apex_application.g_f03(i)
   where  deptno = apex_application.g_f02(i);
end loop;

但是，这并不简单，您需要了解一些正确的方法，例如:

However, it isn't simple and there is a fair bit you need to know to get this right, such as:

• 表格形式的列如何映射到apex_application.g_f03之类的数组(查看页面源代码并查找控件的名称，例如"f03_0001").
• 复选框等某些项目类型的工作方式与其他项目不同
• 如何执行乐观锁定以防止丢失更新

过去在apex.oracle.com上有一个如何"文档，其中对此进行了详细描述，但我最近无法找到它.

There used to be a "how to" document on apex.oracle.com that described this in detail, but I haven't been able to locate it recently.

这篇关于使用PLSQL更新Apex表格形式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！