Variable Expressions

A variable expression specifies a host variable with an optional indicator variable. This form of expression can appear only in embedded SQL statements or SQL statements processed in an Oracle Call Interface (OCI) program.


Description of variable_expression.gif follows
Description of the illustration variable_expression.gif

Some valid variable expressions are:

:employee_name INDICATOR :employee_name_indicator_var