The ON clause is illegal within a compound statement

  Explanation:  The ON clause was specified in a SET TRANSACTION
  statement within a compound statement.  This clause is illegal
  because the compound statement must be in a single database.

  User Action:  Do not use the ON clause within a compound
  statement.  Issue the SET TRANSACTION statement outside of the
  compound statement.