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

NNO-00120: line string: topology name "string" not allowed here

1 Answers  


ORA-24039: Queue string not created in queue table for multiple consumers

1 Answers  


LPX-00282: document cannot have both internal/external and shared DTDs

1 Answers  


ORA-29817: non-supported option with disassociate statement

1 Answers  


ORA-14195: ALLOCATE STORAGE may not be specified for RANGE or LIST partitioned object

1 Answers  






DRG-10837: section string does not exist

1 Answers  


ORA-02234: changes to this table are already logged

1 Answers  


DRG-10601: failed to remove pending DML for this index

1 Answers  


ORA-32632: incorrect subquery in MODEL FOR cell index

1 Answers  


ORA-21779: duration not active

1 Answers  


ORA-16104: invalid Logical Standby option requested

1 Answers  


QSM-01080: invalid dimension, string

1 Answers  


Categories