A script-enabled browser is required for this page to function properly.

Formula Property

Description

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

Refer to Built-in

RECALCULATE

Usage Notes

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