You can use almost all SQL statements within procedures, including the following:
SELECT, UPDATE, DELETE, INSERT, and SET VARIABLE
The CALL statement to execute other procedures
Control statements (see “Control statements”)
Cursor statements (see “Using cursors in procedures”)
Exception handling statements (see “Using exception handlers in procedures”)
The EXECUTE IMMEDIATE statement
Some SQL statements you cannot use within procedures include:
CONNECT statement
DISCONNECT statement
You can use COMMIT, ROLLBACK, and SAVEPOINT statements within procedures with certain restrictions (see “Transactions and savepoints in procedures”).
For details, see the Usage section for each SQL statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.
