Oracle Error SQL*Loader-00487: COUNT clause required for collection string

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.