Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

SQL*Loader-00472

collections can contain only one non FILLER field specification

Cause

More than one non filler field specification is found in a collection field's member field list.


Action

See correct syntax in the Utilities Manual. If indeed there is more than one attribute that makes up the particular collection, then it must be a collection of a object type which needs to be specified using the COLUMN OBJECT field specification syntax.