DB Wiki

This is an old revision of the document!

Exception Handling Setup

CREATE TABLE GGATE.EXCEPTIONS (
EXCP_DATE              TIMESTAMP(6),
REP_NAME               VARCHAR2(10),
TABLE_NAME             VARCHAR2(56),
ERRNO                  NUMBER,
ERRMSG                 VARCHAR2(4000),
OPTYPE                 VARCHAR2(24),
COMMITTIMESTAMP        VARCHAR2(26),
RECCSN                 NUMBER,
RECSEQNO               NUMBER,
LOGRBA                 NUMBER,
LOGPOSITION            NUMBER,
GROUPTYPE              VARCHAR2(12),
FILENAME               VARCHAR2(50),
SRCROWID               VARCHAR2(40),
REPLAG                 NUMBER,
CNT_CDR_CONFLICTS      NUMBER,
CNT_CDR_RESOLUTIONS    NUMBER,
CNT_CDR_FAILED         NUMBER);