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

Oracle Error Message

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

Reason for the Error

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.

Solution

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

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...