When running with sql_mode=ORACLE, MariaDB should emulate Oracle-style transaction related behavior:
- No explicit transaction start (e.g. BEGIN or START statement) is needed.
Transactions start automatically and last until COMMIT or ROLLBACK.
This looks to be equal to SET AUTOCOMMIT=0.
- The BEGIN keyword should always start a code block (a compound statement), even outside of a stored procedure.