| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 |
|
| 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 |
| 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. |