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-02875: smpini: Unable to get shared memory for PGA

1 Answers  


RMAN-04020: target database name "string" does not match channel's name: "string"

1 Answers  


NNF-01003: DCE could not find cell name

1 Answers  


ORA-07498: spstp: Unable to open /dev/resched.

1 Answers  


ORA-22333: cannot reset type "string"."string" due to invalid dependent types and tables

1 Answers  


ORA-13138: could not determine name of object string

1 Answers  


NNL-00956: Hash tables freed: number

1 Answers  


LCD-00205: unbalanced parentheses [string]

1 Answers  


ORA-06007: NETASY: bad dialogue format

1 Answers  


NNL-00251: DEFAULT-FORWARDER-ONLY mode is now enabled

1 Answers  


ORA-25184: column name expected

1 Answers  


ORA-31449: invalid value for change_set_name

1 Answers  


Categories