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

O2F-00317: Error opening the ERRTYPE file for writing

1 Answers  


ORA-12913: Cannot create dictionary managed tablespace

1 Answers  


ORA-36312: (PHYS00) workspace object must be a dimension or dimensioned variable.

1 Answers  


TNS-12169: TNS:Net service name given as connect identifier is too long

1 Answers  


PLS-00552: flexible character set is not allowed on component element

1 Answers  


ORA-22970: name does not correspond to an object view

1 Answers  


ORA-01866: the datetime class is invalid

3 Answers  


PLS-00660: SELF parameter of constructor method must be IN OUT

1 Answers  


PCC-02113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2.

1 Answers  


ORA-25221: enqueue failed, signature specified queue not supporting non-repudiation

1 Answers  


PCC-02134: CMD-LINE: Null option supplied

1 Answers  


ORA-13051: failed to initialize spatial object

1 Answers  


Categories