Databases Reference
In-Depth Information
To be able to do an update of the table, you will need to create a button on your page 3 and name it
SAVE DATA
You can now call the validation function and the update process on application page 3. You will
create a page level validation of type PL/SQL Function Returning Error Message - Validate Collection
Data and make it conditional upon the new button you created (
SAVE DATA
):
BEGIN
RETURN tab form emp pkg.validate collection data;
END;
The process Save Collection to Table will be on submit, and it will be conditional when the button is
pressed (
SAVE DATA
). You will also enter
&T MESSAGE.
in the Success Message of the process
BEGIN
tab form emp pkg.update table from collection
(:p3 deptno,:t message);
END;
Now make a couple of changes in your collection and confirm that the code works as expected.
Figure 3-33 shows some changes to be saved to the source table. Figure 3-34 shows the success message
from saving those changes.
Figure 3-33.
Changes to be saved to the source table
