How to fix the Oracle error SQL*Loader-00486: sql-strings may not be specified for collection field string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00486: sql-strings may not be specified for collection field string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00486: sql-strings may not be specified for collection field string

Reason for the Error SQL*Loader-00486: sql-strings may not be specified for collection field string

A sql-string was specified as part of the description of the field that is inside a nested table or varray. Sql-strings cannot be used to load a field in a varrary or nested tables.

How to fix the Error SQL*Loader-00486: sql-strings may not be specified for collection field string ?

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

Remove the sql-string from the field description. Modify the data file so that it contains the values to be loaded into the column in the collection.