Statements allowed in procedures, triggers, events, and batches

Most SQL statements are acceptable in batches, with the exception of the following:

• ALTER DATABASE (syntax 3 and 4)
• CONNECT
• CREATE DATABASE
• CREATE DECRYPTED FILE
• CREATE ENCRYPTED FILE
• DISCONNECT
• DROP CONNECTION
• DROP DATABASE
• FORWARD TO
• Interactive SQL statements such as INPUT or OUTPUT
• PREPARE TO COMMIT
• STOP SERVER

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

• SELECT statements used in batches
  You can include one or more SELECT statements in a batch. For example:
• EXECUTE IMMEDIATE used in procedures, triggers, user-defined functions, and batches
  The EXECUTE IMMEDIATE statement allows statements to be constructed using a combination of literal strings (in quotes) and variables. For example, the following procedure includes an EXECUTE IMMEDIATE statement that creates a table.