Only one transaction mode may be specified for a transaction

  Explanation:  You specified both the READ_WRITE and READ_ONLY
  transaction modes in a DECLARE TRANSACTION statement.

  User Action:  Specify either transaction mode, not both, for a
  single database.  You can specify different transaction modes
  for different databases in a single DECLARE TRANSACTION
  statement, however.