SQL Statements Allowed in Procedures

You can use almost all SQL statements within procedures.

• SELECT, UPDATE, DELETE, INSERT, and SET VARIABLE
• The CALL statement to execute other procedures
• Control statements
• Cursor statements
• Exception handling statements
• The EXECUTE IMMEDIATE statement

Some SQL statements you cannot use within procedures:

• CONNECT statement
• DISCONNECT statement

You can use COMMIT, ROLLBACK, and SAVEPOINT statements within procedures with certain restrictions.

See the Usage section for each statement in Reference: Statements and Options > SQL Statements.