Databases Reference
In-Depth Information
•
Delete Collection Member:
The process for flagging deleted records to Y. This
process will be conditional using this PL/SQL Expression;
:REQUEST IN ('MULTI ROW DELETE')
You are going to use the following PL/SQL blocks to run these processes. The first PL/SQL block is
for the update process and the second one is for the delete member process:
BEGIN
tab form emp pkg.save emp coll custom (:t message);
END;
BEGIN
tab form emp pkg.delete emp coll custom (:t message);
END;
And, of course, do not forget to put the following into the Process Success Message section:
&T MESSAGE.
Now, you will test your new version of page 3 and change one of the records in your Tabular Form.
Figure 3-29 shows a change being made.
Figure 3-29.
Making a change to a Tabular Form built atop a collection
You should get a similar result to the one shown in Figure 3-30.
