Only one DECLARE TRANSACTION statement is allowed per module

  Explanation:  You can use only one DECLARE TRANSACTION statement
  in a preprocessed module.  It must occur before the first
  executable statement (SELECT, INSERT, UPDATE, CREATE, etc.).

  User Action:  Only use one DECLARE TRANSACTION statement in a
  module.