SQL*Loader-00486: sql-strings may not be specified for
collection field string



SQL*Loader-00486: sql-strings may not be specified for collection field string..

Answer / guest

Cause: A sql-string was specified as part of the description
of the field that is inside a nested table or varray.
Sql-strings cannot be used to load a field in a varrary or
nested tables.

Action: Remove the sql-string from the field description.
Modify the data file so that it contains the values to be
loaded into the column in the collection.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27211: Failed to load Media Management Library

1 Answers  


PCB-00300: Datatype for host variable not supported by ANSI "string"

1 Answers  


NPL-00309: requested ASN.1 type tag string does not match received type tag string

1 Answers  


ORA-14458: attempt was made to create a temporary table with INDEX organization

1 Answers  


ORA-12556: TNS:no caller

1 Answers  






ORA-23403: refresh group "string"."string" already exists

1 Answers  


ORA-30437: all job queue processes have stopped running

1 Answers  


ORA-02485: Invalid _trace_options parameter specification (string)

1 Answers  


PCC-02203: found end of file when not expected

1 Answers  


DRG-11616: URL store: too many redirections trying to access string

1 Answers  


ORA-24003: Queue table index string inconsistent with queue table string

1 Answers  


TNS-00016: INTCTL: error while performing NS send command

1 Answers  


Categories