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

The SQL script running FOR 10 Gb IN oracle9i environment is incompatible. There is no problem IN running the SQL script IN oracle10g environment. The following is the SQL code FOR C IN (SELECT * FROM TABLE (pkg_rj_common.f_split (P_IN_IDS _, ',') LOOP .... The end loop is omitted here; but in 9i execution, the ORA-22905: cannot access rows from a non-nested table item cannot be accessed from a non-nested table item. Analysis on www.2cto.com: The function f_split in the package pkg_assist_common returns the type-type custom array type_varchar_array. The following information is displayed on the Internet: IN oracle9i, cast needs to convert the SQL code FOR C IN (SELECT * FROM TABLE (CAST (pkg_mongo_common.f_split (P_IN_IDS _, ',') AS TYPE_VARCHAR_ARRAY) LOOP .... Www.2cto.com end loop is omitted here; no error is reported after re-compilation. The problem is resolved here.