local collections are not allowed in select statements. Hence the first step is to create a schema level collection.
If the collection is not schema level and being used in SELECT statements then it would cause "PLS-00642: local collection types not allowed in SQL statements"
CREATE OR R...
