The PER_STATEMENT memory duration
A PER_STATEMENT memory pool can be associated with each SQL statement, until execution of the statement is complete and for a prepared statement, until the statement terminates. The statement includes any SQL commands that the SQL statement initiates.
Important: The PER_STATEMENT memory duration is supported
for compatibility with existing UDRs. In new code, you must use either
the PER_STMT_EXEC or PER_STMT_PREP memory duration. These more precise
memory durations replace PER_STATEMENT, which is deprecated.
When a C UDR allocates memory with the PER_STATEMENT memory duration, this memory is available to all routine instances that execute in the same SQL statement.