The COMMIT WORK and ROLLBACK WORK statements close all cursors except those that are declared with a hold.

Does commit close cursor?

A held cursor does not close after a commit operation. ... You specify whether you want a cursor to be held or not held by including or omitting the WITH HOLD clause when you declare the cursor.

What does closing a cursor do?

After all rows have been retrieved from the result set that is associated with a cursor, the cursor must be closed. The result set cannot be referenced after the cursor has been closed. However, the cursor can be reopened and the rows of the new result set can be fetched.