SQL*Loader-00487: COUNT clause required for collection string
Answer / guest
Cause: A VARRAY or NESTED TABLE was defined in the SQL
Loader control file and all of the fields in the VARRAY or
NESTED TABLE are generated by SQL Loader and do not come
from a data file. SQL Loader requires a COUNT clause be
specified so that it knows how many elements to add to the
VARRAY or NESTED TABLE for each row.
Action: Add a COUNT clause to the VARRAY or NESTED TABLE
definition.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-29901: function underlying operator binding does not exist
ORA-12602: TNS: Connection Pooling limit reached
ORA-01666: controlfile is for a standby database
NNO-00123: node "string" has no authoritative parent, data ignored
ORA-30568: cannot drop log group - nonexistent log group
ORA-38477: attribute set cannot be derived from an evolved type or a subtype.
ORA-31060: Resource at path string could not be deleted
ORA-29262: bad URL
NCR-04018: NCRR: Unable to create the TNS address list
LFI-01002: Unable to read line from file.
ORA-14261: partition bound may not be specified when adding this Hash partition
ORA-14099: all rows in table do not qualify for specified partition