ON ROLLBACK RETAIN CURSORS
Specifies system behavior upon rollback to this savepoint with respect to
open cursor statements processed after the SAVEPOINT statement. The
RETAIN CURSORS clause indicates that, whenever possible, the cursors
are unchanged by a rollback to savepoint. For situations where the cursors
are affected by the rollback to savepoint, see “ROLLBACK”.
ON ROLLBACK RETAIN LOCKS
Specifies system behavior upon rollback to this savepoint with respect to
locks acquired after the setting of the savepoint. Locks acquired since the
savepoint are not tracked and are not rolled back (released) on rollback to
the savepoint.