65
DBMS_TRANSACTION

This package provides access to SQL transaction statements from stored procedures.

See Also: Oracle9i SQL Reference

This chapter discusses the following topics:

• Requirements

• Summary of DBMS_TRANSACTION Subprograms

Requirements

This package runs with the privileges of calling user, rather than the package owner SYS.

Summary of DBMS_TRANSACTION Subprograms

Table 65-1 DBMS_TRANSACTION Subprograms

Subprogram
"READ_ONLY Procedure"
"READ_WRITE Procedure"
"ADVISE_ROLLBACK Procedure"
"ADVISE_NOTHING Procedure"
"ADVISE_COMMIT Procedure"
"USE_ROLLBACK_SEGMENT Procedure"
"COMMIT_COMMENT Procedure"
"COMMIT_FORCE Procedure"
"COMMIT Procedure"
"SAVEPOINT Procedure"
"ROLLBACK Procedure"
"ROLLBACK_SAVEPOINT Procedure"
"ROLLBACK_FORCE Procedure"
"BEGIN_DISCRETE_TRANSACTION Procedure"
"PURGE_MIXED Procedure"
"PURGE_LOST_DB_ENTRY Procedure"
"LOCAL_TRANSACTION_ID Function"
"STEP_ID Function"