Oracle Exam 1Z0-151 Topic 3 Question 16 Discussion

View the Exhibit.

The Departments form has form level triggers defined as shown in the Exhibit. You have enabled array DML for the Departments block by setting its DML array size to 5 and setting the Primary Key property of Department id to Yes. You set runtime preferences for Forms Builder to use array processing.

You want to test that array processing is actually occurring, so, as shown in the Exhibit, the On-Update, On-Delete, and on insert triggers have code that:

1. Displays a message to indicate which trigger is firing for which record?

2. Does the thing (either updates, deletes, or inserts)

The other triggers simply display a message, indicating the trigger that is firing.

You run the form from Forms Builder, but from the messages, you can tell that array processing is not occurring. What should you change so that array DML gets implemented?