How to fix the Oracle error SQL*Loader-00428: count for field string not stored in character or integer field?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00428: count for field string not stored in character or integer field with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00428: count for field string not stored in character or integer field

Reason for the Error SQL*Loader-00428: count for field string not stored in character or integer field

The count clause for a field references another field, but the referenced field is not a character or integer datatype.

How to fix the Error SQL*Loader-00428: count for field string not stored in character or integer field ?

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

Modify the count field so that it reference a a data field that has the count in an integere or character format.