Valentina Compound Statement Syntax

• BEGIN ... END Compound statement Syntax
• DECLARE Statement Syntax
• Variables in Stored Routines
• Cursors
• Error Handling - NEW in 3.0
• Flow Control Constructs - NEW in 3.0
• Loops - NEW in 3.0
• Return Statement - NEW in 3.0

This section describes the syntax for the BEGIN … END compound statement and other statements that can be used in the body of stored routines: stored procedures, functions and triggers. These objects are defined in terms of SQL code that is stored inside of database schema for later use.