SQL*Loader-00402: Unable to determine length of column
string from specification



SQL*Loader-00402: Unable to determine length of column string from specification..

Answer / guest

Cause: The specified datatype does not have an implied
length (for example, a numeric external or RAW datatype), it
is not specified with delimiters, no length was specified,
and a length cannot be determined from a POSITION clause.

Action: If a POSITION clause is specified, adding an end
location to it produces a length specification. This clause
then has the form POSITION(start:end) A length can also
specified after the datatype, as in INTEGER EXTERNAL (6)
Finally, the field could be specified with delimiters, or
the datatype changed to one that has an implied length.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMG-00862: assert failure, inconsistency in merged area labels

1 Answers  


TNS-00541: underlying transport does not exist.

1 Answers  


ORA-22065: number to text translation for the given format causes overflow

1 Answers  


PCC-02444: Invalid combination of descriptor and non-descriptor clauses

1 Answers  


O2I-00117: Internal error: No message file for component O2U

1 Answers  






ORA-09719: osncui: invalid handle.

1 Answers  


ORA-23441: object does not exist for refresh group template

1 Answers  


ORA-16951: Too many bind variables supplied for this SQL statement.

1 Answers  


ORA-28656: incomplete attribute specification

1 Answers  


ORA-13757: "SQL Tuning Set" "string" is active.

1 Answers  


ORA-14313: Value string does not exist in partition string

1 Answers  


ORA-13427: invalid BLOB parameter for output

1 Answers  


Categories