The SQL script running 10 Gb in Oracle9i environment is incompatible.

There is no problem running in Oracle10g environment, but in Oracle9i execution, it will be inexplicably reported ORA-22905: cannotaccessrowsfromanon-neste

There is no problem running in Oracle 10g environment, but in Oracle 9i execution, it will be inexplicably reported ORA-22905: cannot access rows from a non-neste

There is no problem in running Oracle 10g environment, as shown below:

For c in (SELECT * from table (pkg_1__common.f_split (P_IN_IDS _, ',') LOOP
.... Omitted here
End loop;

However, in Oracle 9i execution, the ORA-22905: cannot access rows from a non-nested table item cannot access rows from non-nested table items.

Analysis:

The f_split function in the pkg_1__common package returns the type-type custom array type_varchar_array.

Check on the Internet: cast conversion is required under oracle9i.

For c in (SELECT * from table (CAST (pkg_assist_common.f_split (P_IN_IDS _, ',') AS TYPE_VARCHAR_ARRAY) LOOP
.... Omitted here
End loop;

After re-compilation, no error is reported. Now the problem is solved. Record it here.