Oracle DBMS_TG_DBG
Version 19.3

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
Clear all failpoints dbms_tg_dbg.clear_failpoint;
exec dbms_tg_dbg.clear_failpoint;
 
SET_FAILPOINT
Set a Transaction Guard failpoint dbms_tg_dbg.set_failpoint(
failpoint IN NUMBER,
sid       IN NUMBER,
serial    IN NUMBER);
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;

Related Topics
Built-in Functions
Built-in Packages
RAC
Transaction Guard
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx