Oracle | DBMS_TG

Oracle DBMS_TG_DBG Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

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;

      

      PL/SQL procedure successfully completed.

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);

      

      PL/SQL procedure successfully completed.

SET_SESSION_DRAINABLE

Sets the current session as drainable dbms_tg_dbg.set_session_drainable;

exec dbms_tg_dbg.set_session_drainable;

      

      PL/SQL procedure successfully completed.