Databases Reference
In-Depth Information
Let's extend the package
tab form emp pkg
by adding the first function described, shown in Listing
3-4.
Listing 3-4.
Checksum—Function 1
FUNCTION compare checksum change (p array IN NUMBER)
RETURN BOOLEAN;
FUNCTION compare checksum change (p array IN NUMBER)
RETURN BOOLEAN
IS
BEGIN
IF apex application.g f02 (p array) IS NOT NULL
THEN
IF apex application.g fcs (p array) <>
wwv flow item.md5 (apex application.g f02 (p array),
apex application.g f03 (p array),
apex application.g f04 (p array),
apex application.g f05 (p array),
apex application.g f06 (p array),
apex application.g f07 (p array),
apex application.g f08 (p array),
apex application.g f09 (p array),
apex application.g f11 (p array)
)
THEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
ELSE
RETURN TRUE;
END IF;
END compare checksum change;
Caution
As already mentioned, the items of type Simple Checkbox or Popup Key LOV will reserve two arrays for
one item. This is the reason for the gap between the
g f09
and
g f11
arrays.
After that, add the second function, shown in Listing 3-5.
Listing 3-5
. Checksum—Function 2
FUNCTION compare checksum table (p array IN NUMBER)
RETURN BOOLEAN;
FUNCTION compare checksum table (p array IN NUMBER)
RETURN BOOLEAN
