ORA-6502 Executing Dbms_wm.refreshtable In A Loop
(Doc ID 2437802.1)
Last updated on APRIL 17, 2023
Applies to:Workspace Manager - Version 220.127.116.11 and later
Information in this document applies to any platform.
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
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