APEX HTMLDB_APPLICATION与checkbox

最新推荐文章于 2020-12-02 17:14:47 发布

转载最新推荐文章于 2020-12-02 17:14:47 发布 · 864 阅读

文章标签：

#application #arrays #reference #parsing #variables #processing

apex 专栏收录该内容

37 篇文章

订阅专栏

本文介绍了Oracle APEX中的HTMLDB_APPLICATION包，该包提供了应用程序运行时的重要全局变量，如当前用户ID、应用ID等。此外，还详细解释了如何通过HTMLDB_ITEM包动态创建页面元素，并利用HTMLDB_APPLICATION包中的数组处理这些元素的数据。

The APEX HTMLDB_APPLICATION

The HTMLDB_APPLICATION package exposes several global variables used internally by the APEX engine.

g_user: This is the ID of the currently logged in user.
g_flow_id: This is the ID of the currently running application.
g_flow_step_id: This is the page ID for the currently running application page.
g_flow_owner: This is the parsing schema for the current application.
g_request: This is the most recent REQUEST. Requests are set by buttons in APEX.

The HTMLDB_APPLICATION package also exposes a global array which references values from certain page items. The HTMLDB_ITEM package can be used to create items on an application page. This means the developer creates them programmatically during page rendering instead of creating the page item with a wizard. When items are created like this, they are provided a numeric value. APEX then references the page item in an array. Up to 50 items can be created using the HTMLDB_ITEM package and still be allowed to reference them using HTMLDB_APPLICATION package. An example of this was provided during the checkbox explanation in an earlier chapter of this book. There, the htmldb_item.checkbox procedure was used to add checkboxes to a report. The arrays in the htmldb_application package were then used to reference the checkbox during page processing.

For the checkboxes shown in Figure 10.3, the HTML code that was rendered by using the htmldb_item.checkbox procedure looks like the following:

When the page is submitted, only the checkboxes which are checked will appear in the arrays of the htmldb_application package. For the example above, there will be three array elements in the array named g_f10. Programmatically, it is possible to loop through the array in a page processing process and update the data in the database. The following code shows an example of how the code to loop through the htmldb_application.g_f10 array would look:

begin
for i in 1..htmldb_application.g_f10.count loop
    update class
    set    available_flag = 'Y'
    where class_id = htmldb_application.g_f10(i);
end loop;
end;

While looping through the array and using the sample checkboxes from above, the values one, two, and four would appear in the array.

转载自：

http://www.dba-oracle.com/t_easy_html_db_application.htm