Databases Reference
In-Depth Information
v message := LTRIM (v message, '<br/>');
RETURN v message;
END validate emp comm;
The update/insert process will loop through the array of
EMPNO (g f02)
and, for all rows containing
the primary key, compare the original checksum with the new calculated checksum. If there is a
difference, it will update the corresponding rows and update the counter. For the added rows where the
array is NULL, it will insert a new row. You will use this PL/SQL block to start that process:
BEGIN
tab form emp pkg.save emp custom (:t message);
END;
and put the
&T MESSAGE.
in the Process Success Message section.
The validation process is fairly simple. It will also loop through the array of
EMPNO (g f02)
and check
if there is an entry for the COMM column
(g f08)
where
DEPTNO (g f09)
is different than
SALES (value
30)
. You will use this PL/SQL block for the validation:
BEGIN
RETURN tab form emp pkg.validate emp comm;
END;
You can now test your form to confirm that it works as expected. Figures 3-21 through 3-25 walk you
through the steps in the test.
Figure 3-21.
Click the Add Row button to add a new row at the top of the form.
