SQL*Loader-00427: a field condition references a non-scalar
field or a LOB field string



SQL*Loader-00427: a field condition references a non-scalar field or a LOB field string..

Answer / guest

Cause: The field condition is referencing a field which is
either a nested table, varray, column object, LOB or BILE
field. These fields with these typescannot be references by
other field.

Action: Correct the NULLIF, DEFAULTIF, or WHEN clauses to
reference only non-LOB scalar data fields.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02818: Less than the number of blocks requested was read in

1 Answers  


LFI-00129: Invalid option string were specified on an input only file.

1 Answers  


ORA-23368: name string cannot be null or the empty string

1 Answers  


ORA-00376: file string cannot be read at this time

1 Answers  


ORA-31604: invalid string parameter "string" for object type string in function string

1 Answers  






ORA-16095: Dependent destination removal for inactivation

1 Answers  


ORA-08309: sllfop: Cannot fstat file

1 Answers  


DRG-10602: failed to queue DML change to column string for primary key string

1 Answers  


ORA-01120: cannot remove online database file string

1 Answers  


ORA-31025: Invalid document element

1 Answers  


ORA-28661: Object already has COMPRESS clause specified

1 Answers  


DRG-12508: null stop words are not allowed

1 Answers  


Categories