All SQL statements are acceptable in batches (including data definition statements such as CREATE TABLE, ALTER TABLE, and so on), with the exception of the following:
CONNECT or DISCONNECT statement
ALTER PROCEDURE or ALTER FUNCTION statement
You also cannot use host variables in batches.
The CREATE PROCEDURE statement is allowed, but must be the final statement of the batch. Therefore a batch can contain only a single CREATE PROCEDURE statement.
