While Registering Integrated Extract Fails With ORA-06502:PL/SQL:Numeric Or Value Error Character String Buffer Too Small
(Doc ID 2604378.1)
Last updated on APRIL 17, 2023
Applies to:Oracle GoldenGate - Version 18.104.22.168.2 and later
Information in this document applies to any platform.
While registering MA integrated Extract fails with following errors:
Title:EXTRACT (Integrated) added.
Title:Cannot register or unregister EXTRACT <EXT_NAME> because of the following SQL error: OCI Error ORA (status = 6502-ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 253 ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 296 ORA-06512: at line 1 ).
Title:Deleted EXTRACT <EXT_NAME>.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document