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.