Specifies a single PL/SQL expression that determines the value for a formula calculated item. The expression can reference Built-in or user-written subprograms.
Applies to item
Set Oracle Forms
You cannot enter an entire PL/SQL statement as your formula; accordingly, do not terminate your calculation expression with a semicolon. Oracle Forms adds the actual assignment code to the formula internally do not code it yourself. For example, instead of coding an entire assignment statement, code just the expression
:emp.sal + :emp.comm
Oracle Forms will internally convert this into a complete statement, e.g.,
:emp.gross_comp := (:emp.sal + :emp_comm);
Required/Optional required if Calculation Mode property is set to Formula