Embedded Usage
In addition to aborting all or part of the current transaction, an embedded ROLLBACK statement:
• Closes all open cursors
• Discards all statements that were prepared in the current transaction
The TO savepoint_name clause cannot be included if there are open cursors in the transaction. Also, when a savepoint is specified in the ROLLBACK statement, the DBMS Server discards only those statements that were prepared after the declaration of the specified savepoint.
Savepoint_name cannot be specified using a host language variable.