How to fix the Oracle error SQL*Loader-00646: lob set to EMPTY in column string, row number, table string?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00646: lob set to EMPTY in column string, row number, table string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00646: lob set to EMPTY in column string, row number, table string

Reason for the Error SQL*Loader-00646: lob set to EMPTY in column string, row number, table string

Encountered errors (e.g. parsing errors in LOBFILE) while loading LOBs. The row will remain in the table and its LOB column will be initialized to empty. Loading of other records will continue.

How to fix the Error SQL*Loader-00646: lob set to EMPTY in column string, row number, table string ?

You can fix this error in Oracle by following the below steps

Correct the data file (see accompanying messages) and reload.