Stored procedures

Nested stored procedures

You can now call stored procedures and execute meta-functions from inside other stored procedures. For details, see Nested stored procedures.

Transaction semantics

Stored procedures now only automatically commit after successful execution of the entire stored procedure, including any nested stored procedures. You can also manually commit with PERFORM COMMIT. For details, see Transaction semantics.

Previously, stored procedures committed the transaction before executing, and each embedded SQL statement executed in its own autocommitted transaction.

Session semantics

Stored procedures now support session semantics. All session-based changes made in a stored procedure persist after execution.