The statement given below is for your reference.

The database server automatically issues the prepare statement to update any prepared objects that reference the table.

Any subsequent reference to the cursor after the ROLLBACK statement results in an error indicating that the cursor was closed.