DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION Fails With ORA-6502

(Doc ID 343297.1)

Last updated on FEBRUARY 26, 2006

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1 to 10.2
This problem can occur on any platform.

Symptoms

This problem is characterized by the error 'ORA-06502: PL/SQL: numeric or value error: character string buffer too small' error when running DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION on a 10.1 or a 10.2 instance:

 

SQL> exec dbms_streams_adm.remove_streams_configuration;
ERROR at line 1:
ORA-06502 : PL/SQL: numeric or value error: character string buffer too small
ORA-06512 : at "SYS.DBMS_STREAMS_ADM", line 1735
ORA-06512 : at line 1.




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