How to fix the Oracle error SQL*Loader-00422: constant element count of number for column string is greater than maximum, number?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00422: constant element count of number for column string is greater than maximum, number with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00422: constant element count of number for column string is greater than maximum, number

Reason for the Error SQL*Loader-00422: constant element count of number for column string is greater than maximum, number

The number of elements specified for a varray column in a table is greater than the maximum number of elements allowed for the type of the varray column.

How to fix the Error SQL*Loader-00422: constant element count of number for column string is greater than maximum, number ?

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

Increase the number of elements allowed for the type or remove unwanted elements from the data file.