Oracle APEX Cookbook - Second Edition

Updating a table with the hidden primary key

The APEX_ITEM API is a PL/SQL package that you can use to programmatically put items on the screen. The package also contains a function to put hidden items on the screen. Hidden items are items that are placed in a webpage but are not visible. However, they can contain a value. In this way, you can make each row in a report unique. We will make an updatable report which makes use of the APEX_ITEM API.

Getting ready

Make sure you have access to the table APP_EVENTS.

How to do it...

First, we will make a classic report based on the APP_EVENTS table.

1. In the Application Builder, click on the Create Page button.
2. Select Report.
3. Select Classic report.
4. Enter a name for the page and click on Next.
5. Select Do not use ...