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

ORA-10615: Invalid tablespace type for temporary tablespace

1 Answers  


ORA-00472: PMON process terminated with error

1 Answers   TCS,


SQL*Loader-00950: Error shipping data structures across 2-task

1 Answers  


NNL-00215: Scheduled specified index number's next auto-refresh to occur in string

1 Answers  


RMAN-08106: channel string: restoring block(s)

1 Answers  


ORA-25306: Queue table string has buffered queues. Cannot alter

1 Answers  


ORA-12226: TNS:operating system resource quota exceeded

1 Answers  


ORA-14041: partition bound may not be specified for resulting partitions

1 Answers  


ORA-25000: invalid use of bind variable in trigger WHEN clause

1 Answers  


ORA-12206: TNS:received a TNS error during navigation

1 Answers  


NNL-00049: Output in string cannot be renamed to string

1 Answers  


ORA-16556: Error message is in XML already.

1 Answers  


Categories