RELEASE ──> statement-name ──> typebox (;)
The RELEASE statement releases all resources used by a prepared
statement in dynamic SQL. RELEASE is valid only in precompiled
programs and in module language procedures.
When you prepare an SQL statement for dynamic execution, you
cannot delete any schema definitions (such as constraints,
indexes, or tables) referred to directly or indirectly by the
statement until you release the statment. The RELEASE statement
gives you a way to explicitly release prepared statements. Note
that SQL also implicitly releases dynamic SQL statements in the
following circumstances:
1. After an EXECUTE IMMEDIATE statement
2. When a PREPARE statement refers to an already-prepared
statement name
3. When the same authorization identifier is declared for a
schema referred to in a prepared statement