Variables in Oracle Forms

Variable is used to store values from form items.

• Local Variables:- The local variable is a PL/SQL variable whose value is only accessible with in the trigger or user named sub Programs

• Global Variable:- The Global variable value is accessible to trigger and subprograms in any modules. Global variables in Oracle Forms always store the data as character of up to 255 for all kinds of usages. In case you want to use a numeric value for global variable then remember that Oracle will convert it to character, therefore value needs to be converted to number for usage. Global variable size is 4000 bytes. Global variables can be declared in two ways. 

• System Variable:- System variable is used to track of runtime status condition.