Home Oracle Commands Oracle Packages
PL/SQL Books

PL/SQL Packages DBMS_TRANSACTION

Control SQL transactions.

Subprocedures:

READ_ONLY 
READ_WRITE 
ADVISE_ROLLBACK 
ADVISE_NOTHING 
ADVISE_COMMIT 
USE_ROLLBACK_SEGMENT

COMMIT_COMMENT 
COMMIT_FORCE 
COMMIT 

SAVEPOINT 

ROLLBACK 
ROLLBACK_SAVEPOINT 
ROLLBACK_FORCE 

BEGIN_DISCRETE_TRANSACTION 
PURGE_MIXED 
PURGE_LOST_DB_ENTRY 
LOCAL_TRANSACTION_ID Function 
STEP_ID Function  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related Commands:

Related Packages:




Back to the Top

Simon Sheppard
SS64.com