1 – SQL statement
Specifies a single executable SQL statement.
Executable SQL statements undergo processing during module
compile time but do not execute until the program runs. SQL
executes the simple statement when the procedure in which it
is embedded is called by a host language module. (Nonexecutable
SQL statements are those that SQL processes completely when it
compiles an SQL module but are not executed at run time.) See the
Oracle Rdb SQL Reference Manual for information about which SQL
statements are executable.
The SQL statement must use names specified in the procedure's
formal parameters wherever it refers to parameters.