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-24400: error occured while creating connections in the pool

1 Answers  


QSM-02015: Index Organized Table (IOT) present in FROM list

1 Answers  


LFI-01515: truncate() failed.

1 Answers  


DRG-11005: invalid create index parameter string

1 Answers  


ORA-30504: system triggers cannot have a FOR EACH ROW clause

1 Answers  


ORA-14044: only one partition may be moved

1 Answers  


RMAN-06739: database "string" is not found in the recovery catalog

1 Answers  


NZE-28756: callback failure to allocate memory

1 Answers  


EXP-00070: attempt to free unallocated memory

1 Answers  


NNL-00001: request argument "string" is invalid

1 Answers  


DRG-10762: index owner does not have access to procedure string

1 Answers  


LPX-00655: Invalid output comment '~S'.

1 Answers  


Categories