SQL*Loader-00487: COUNT clause required for collection string
- 1 Answers
- 2160 Views
- I also Faced
- E-Mail Answers
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 |
DRG-10852: Invalid scoring type string specified for query template
AMD-00132: dimension #string: RDBMS GID column data type not specified
RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
ORA-13601: The specified Advisor string does not exist.
IMP-00090: Unexpected DbmsJava error number at step number while creating string
PCC-02023: Found end of file while scanning a PL/SQL statement
SQL*Loader-00655: cannot load object-relational XML attribute using direct path
ORA-38416: A stored attribute may not be longer then 300 characters.
ORA-24166: evaluation context string.string has errors
ORA-08342: sropen: failed to open a redo server connection
ORA-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue
ORA-30357: this PL/SQL function cannot be supported for query rewrite
Oracle Errors 
