Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-00345: redo log write error block string count string

1 Answers  


ORA-22613: buflen does not match the size of the scalar

1 Answers  


ORA-38411: invalid datatype for the column storing expressions

1 Answers  


TNS-00518: Incomplete read or write

1 Answers  


ORA-06577: output parameter not a bind variable

1 Answers  






ORA-03292: Table to be truncated is part of a cluster

1 Answers  


RMAN-07501: searching for all files in the recovery area

1 Answers  


ORA-31010: XML element index string exceeds maximum insertion index string

1 Answers  


ORA-19629: no files in specified archivelog SCN range

1 Answers  


ORA-25445: invalid column number: string for table alias: string

1 Answers  


DRG-10549: length of the object name string exceeded the limit

1 Answers  


ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

1 Answers  






Categories