DDL TRIGGER RESULTING IN GoldenGate ORA-01426: NUMERIC OVERFLOW, OGG-00524, ORA-06512 (Doc ID 1456177.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Extract abended with error:

2012-02-29 11:45:31  ERROR   OGG-00524  Oracle GoldenGate Capture for Oracle, extgrp1.prm:  Error in DDL trigger has been detected: ERROR: DDL sequence [], marker sequence [893863], DDL trace log file [/usr/local/opt/oracle/admin/ipag1pdb/diag/rdbms/ipag1pdb_dg1/ipag1p1/trace\ggs_ddl_trace.log], error code -1426 error message ORA-01426: numeric overflow, error stack: ORA-06512: at "GGSUSER.DDLREPLICATION", line 95 ORA-06512: at "GGSUSER.DDLREPLICATION", line 234 ORA-06512: at line 94 . Please investigate trace log file or contact Oracle Support.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms