My Oracle Support Banner

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 19.1.0.0.2 and later
Information in this document applies to any platform.

Symptoms

While registering MA integrated Extract fails with following errors:

Title:EXTRACT (Integrated) added.
Code:OGG-08221
Severity:ERROR
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 ).
Code:OGG-08100
Severity:INFO
Title:Deleted EXTRACT <EXT_NAME>.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.