Transaction statements not allowed in atomic blocks

  Explanation:  You have used a transaction statement (SET
  TRANSACTION, COMMIT, ROLLBACK) in a compound statement that
  specifies ATOMIC.

  User Action:  Use transaction statements only in non-atomic
  blocks.