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(cmntIN 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(xidIN VARCHAR2[,scnIN 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_transactionIN 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(xidIN 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 ...