How to fix the Oracle error SQL*Loader-00487: COUNT clause required for collection string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00487: COUNT clause required for collection string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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.

How to fix the Error SQL*Loader-00487: COUNT clause required for collection string ?

You can fix this error in Oracle by following the below steps

Add a COUNT clause to the VARRAY or NESTED TABLE definition.