Oracle | DBMS_TG

Oracle DBMS_TG_DBG Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Transaction Guard application continuity debugging. Enables an application to determine the outcome of a transaction.

AUTHID DEFINER

Constants

Name	Data Type	Value
TG_FAILPOINT_PRE_COMMIT	NUMBER(2)	1
TG_FAILPOINT_POST_COMMIT	NUMBER(2)	2
TG_FAILPOINT_FORCE_OUTCOME	NUMBER(2)	4

Dependencies

DBMS_TG_DBG_LIB

Documented No

First Available 12.2.0.1

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/dbmsappcont.sql

Subprograms

CLEAR_FAILPOINT

SET_FAILPOINT

SET_SESSION_DRAINABLE

CLEAR_FAILPOINT

Clear all failpoints dbms_tg_dbg.clear_failpoint;

exec dbms_tg_dbg.clear_failpoint;

SET_FAILPOINT

Set a Transaction Guard fail point dbms_tg_dbg.set_failpoint( failpoint IN NUMBER, sid IN NUMBER DEFAULT NULL, serial IN NUMBER DEFAULT NULL);

exec dbms_tg_dbg.set_failpoint(dbms_tg_dbg.tg_failpoint_post_commit);

SET_SESSION_DRAINABLE

Sets the current session as drainable dbms_tg_dbg.set_session_drainable;

exec dbms_tg_dbg.set_session_drainable;