Oracle Error Message
SQL*Loader-00487: COUNT clause required for collection string
Reason for the Error
A VARRAY or NESTED TABLE was defined in the SQL Loader control file and all of the fields in the VARRAY or NESTED TABLE are generated by SQL Loader and do not come from a data file. SQL Loader requires a COUNT clause be specified so that it knows how many elements to add to the VARRAY or NESTED TABLE for each row.
Solution
Add a COUNT clause to the VARRAY or NESTED TABLE definition.
