The draft ISO SQL3 standard states that on a rollback, all cursors (even those cursors opened WITH HOLD) should close.

• ISO SQL3标准草案声明:在回退时,所有游标(甚至是那些打开为WITH HOLD的游标)都应关闭。