SYSTEM.CURSOR_VALUE
SYSTEM.CURSOR_VALUE represents the value of the item where the cursor is located. The value is always a character string.
Be aware that in triggers where the current navigation unit is not the item, such as Pre-Record , and Pre-Block triggers, SYSTEM.CURSOR_VALUE will contain the value of the item navigated from, rather than the value of the item navigated to.
Assume that you want to create a user-defined procedure that takes the value of the item where the cursor is located, multiplies the value by a constant, and then reads the modified value into the same item. The following user-defined procedure uses the COPY Built-in to perform this function.
PROCEDURE CALC_VALUE IS
new_value NUMBER;
BEGIN
new_value := TO_NUMBER(:System.Cursor_Value) * .06;
Copy(TO_CHAR(new_value), :System.Cursor_Item);
END;