Oracle in a Nutshell

Calls

PROCEDURE DBMS_TRANSACTION.ADVISE_COMMIT;

Advises remote databases that in-doubt distributed transactions should be committed if possible.

PROCEDURE DBMS_TRANSACTION.ADVISE_NOTHING;

Removes advice from remote databases regarding in-doubt distributed transactions.

PROCEDURE DBMS_TRANSACTION.ADVISE_ROLLBACK;

Advises remote databases that in-doubt distributed transactions should be rolled back.

PROCEDURE DBMS_TRANSACTION.BEGIN_DISCRETE_TRANSACTION;

Sets the current transaction to use discrete transaction processing.

PROCEDURE DBMS_TRANSACTION.COMMIT;

Commits the current transaction.

PROCEDURE DBMS_TRANSACTION.COMMIT_COMMENT (cmnt IN VARCHAR2);

Commits the current transaction and sends cmnt as the in-doubt transaction comment to remote databases during distributed transactions.

PROCEDURE DBMS_TRANSACTION.COMMIT_FORCE (xid IN VARCHAR2 [,scn IN VARCHAR2 DEFAULT NULL]);

Forces the local portion of the in-doubt distributed transaction identified by transaction id xid and (optionally) system change number scn to commit.

FUNCTION DBMS_TRANSACTION.LOCAL_TRANSACTION_ID (create_transaction IN BOOLEAN := FALSE) RETURN VARCHAR2;

Returns Oracle’s unique identifier for the current transaction, optionally beginning a new transaction when create_transaction is TRUE.

PROCEDURE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY (xid IN VARCHAR2);

Forces Oracle to purge all local entries for the distributed transaction identified by xid when a participating node has been permanently lost. New with Oracle8 ...