Oracle Solution for Error ora-22600

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

What triggered the Error:

oduction 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.

What should we do to fix it:

lete 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.