ORA-6502 Executing Dbms_wm.refreshtable In A Loop (Doc ID 2437802.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Executing DBMS_WM.REFRESHTABLE within a loop raises an ORA-6502 error.

A procedure with a table that is versionenabled does the following:
- updates records in live
- updates the same primary keys within some workspaces, just to be sure that some workspaces has conflicts
- run dbms_wm.refreshtable using a where clause to refresh only the affected records
- display a message whenever there are conflicts.

The refreshtables is executed within a loop to be performed on every workspace, and at some point it raises
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "WMSYS.LT", line 7234

Changes

Cause

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