Oracle Error ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

Oracle Error Message

ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

Reason for the Error

Production Oracle8 (8.0.3 and beyond) encounters some VARRAY data which was created and stored by Oracle8 8.0.2 (Beta 2). Production Oracle8 cannot understand or process such VARRAY data.

Solution

Delete the VARRAY data from the table by dropping the table, deleting the rows, or nulling out the VARRAY columns, and then re-insert the VARRAY data. There is no provided script or tool to help automate this conversion.