All the cursor operations must be in an explicit user transaction, or multi-statement transaction, with read-repeatable isolation level or serializable isolation level.