SQL statements allowed in procedures and triggers

You can use almost all SQL statements within procedures and triggers, 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 and triggers).
Exception handling statements (see Using exception handlers in procedures and triggers).
The EXECUTE IMMEDIATE statement.

Some SQL statements you cannot use within procedures and triggers include:

You can use COMMIT, ROLLBACK and SAVEPOINT statements within procedures and triggers with certain restrictions (see Transactions and savepoints in procedures and triggers).

For more information, see the Usage for each SQL statement in the chapter SQL Statements.