I initially ran into the tree limit size Oracle WM has (30). Our process is to create a new workspace outside the tree and update the data. While doing so I received this error.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06612: at "WMSYS.WM$154$DELETE$", line 5
ORA-04088: error during execution of trigger 'WMSYS.WM$154$DELETE$'
After reviewing the data not sure why it stopping. I wound up manually deleting the data 50 rows at a time until I came to the error again. Then narrowed it down to one row. I cannot delete this row and keep getting this error. There is nothing special about this row. Other rows of data was longer more complex. No special characters, just this one row won't delete.
Can anyone shed any light on this Oracle error?
Mark