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
Cursor statements
Exception handling statements
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 the Usage section for each statement in Reference: Statements and Options > SQL Statements.