My Oracle Support Banner

OGG Extract Abend with GGS ERROR 190 Invalid Numeric Data Detected Error Converting Numeric from Oracle to ASCII on Column Raw Length 1, Raw Data: 0x00 (Doc ID 1316627.1)

Last updated on JANUARY 31, 2017

Applies to:

Oracle GoldenGate - Version to [Release 10.4.0 to 11.2]
Information in this document applies to any platform.
INTERNAL Checked for currency on 11-Dec-2012


GGS ERROR 190 Formatting error on: table name <table name>, rowid <rowid>, XID 1.234.567, position (Seqno 4321, RBA 1234567). Invalid numeric data detected. Error converting numeric from Oracle to ASCII on column <column_name>, raw length 1, raw data: 0x00.


select dump(<column_name>,10), vsize(<column_name>), to_char(<column_name>,'0000.9999')
from <table name> a where rowid in ('<rowid>');
Typ=2 Len=1: 0




To view full details, 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 a vibrant support community of peers and Oracle experts.