The reason is, that array (or cursor) is constructed and populated in PL/SQL engine, SELECT statement execution is performed in SQL engine and Oracle must convert complete result set to switch between ...