Applies To
OraConnection
OraDatabase
OraSession
Description
Ends the current transaction and rolls back all pending changes to the
database.
Usage
oraconnection.Rollback
orasession.Rollback
oradatabase.Rollback
Remarks
When this method is invoked, all OraDynaset objects that share the specified
session or connection are given the opportunity to cancel the rollback request.
If they do not cancel the request, they are then advised when the rollback
succeeds.
This feature is useful primarily for dynasets that are created as part of an
Oracle Data Control's operation. For such dynasets, the Validate event is sent
to allow them to cancel the rollback request.
OraConnection, OraDatabase: Rollback rolls back all pending transactions within the specified connection.
This method has no effect if a transaction has not begun. When a session-wide
transaction is in progress, you can use this call to prematurely roll back the
transactions for the specified connection.
OraSession: Rollback rolls back all pending transactions within the specified session.
Rollback is valid only when a transaction has been started. If a transaction has
not been started, use of Rollback results in an error.
Note: If an OraDatabase object has been enlisted with Microsoft Transaction Server (MTS) and is part of a global MTS transaction, this method has no effect.